VB SQL search similar records
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:
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.