SELECT * FROM Books WHERE Author='H. G. Wells'

The above statement will work fine. But what if the user inputs H G Wells, or there is an entry in the DB as H G Wells? How can I make sure all his books are selected in any case.





I can think of a couple of ways of overcoming it, though I'm unsure what the overhead and the pros and cons are.





My question to the forum is: What is the best way of dealing with this situation?





Thanks, in anticipation...


Mark