This is sort of off topic but I think it should be said.

Like is good for searches, but I prefer to use soundex for searches..
The great thing about soundex is that it gets words that sound alike not just spelled alike.

This works really good in Oracle 9i where you can index soundex for speed.

Here is a example.

    select * from demographics where soundex(name) = soundex(?)
[download]