String comparison

[emozley]

Hi,

I have written a telephone directory app that has a search box. The idea is you can search for a name and it will compare what you've typed in against first name and surname in the database.

I want to make it so if you search for "Ed Mozley" you still get a match:

This query works in Access but not in SQL - what is the equivalent please?

"OR bwbnet_Users.FirstName & ' ' & bwbnet_Users.Surname LIKE '" & search & "%' "

Thanks very much

Ed

 

[gmmastros]

Replace the first 2 & with +

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

You better parse the passed string into 2 parts, e.g.

declare @SearchStr varchar(max) = 'Ed Mozley'

declare @FirstName varchar(100), @LastName varchar(100)

select @FirstName = substring(@SearchStr,1, 
charindex(' ',@SearchStr + ' ') - 1), @LastName =
substring(@SearchStr, charindex(' ',@SearchStr + ' ') + 1,
len(@SearchString))

select * from myTable where FirstName = @FirstName and SurName = @LastName

---
from the top of my head.


PluralSight Learning Library