Hi there

I am trying to seach for similar records in a database, so for example, if the user searches for 'Dere'
it will return records that are similar like:

Derrick
Dereck
Derick
Derik

I am attempting this with the following SQL :
SELECT UserName FROM Users WHERE 'derek' Like '%'

Nothing is returned unfotunately, any suggestions? Any help or adive will be much appreciated thanks.

derek

Try:

SELECT UserName FROM Users WHERE UserName Like 'dere%'"

Will return only Dereck from you list.


HTH,

Bob