Wildcard in SQL string

[Jusenkyo]

Hello all

Just an easy one, ive forgotten how to to a fuzzy search in a SQL string. The code I have so far is:

cmd.CommandText = "SELECT [First Name] + ' ' + [Surname] as EmployeeName FROM dbo.qryEmployeeDetails Where [First Name] + ' ' + [Surname] = ('" & Username & "') "

I want to find all the matching names, even if they are spelt a little differently.

Any ideas?
Cheers!
J

 

[PHV]

Take a look at the Like operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Craig0201]

Or for a more complete answer, look up Soundex algorithms.