View Single Post
  #1 (permalink)  
Old March 24th, 2006, 01:27 PM
Derek_05 Derek_05 is offline
Authorized User
 
Join Date: Dec 2005
Location: London, , United Kingdom.
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default VB SQL search similar records

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


Reply With Quote