Error on case query

wussupbuddy · #1 (**permalink**) 04-28-09, 07:09

I'm getting an error while trying to execute the following statement. What's wrong with it?

"Select * from master where case(isnull(firstname) when 1 then '' else firstname end +' '+ case(isnull(lastname) when 1 then '' else lastname end like '%" & Text1.Text & "%'"

ashish_mat1979 · #2 (**permalink**) 04-29-09, 06:18

Try using "CONCAT" for joining your case results instead of "+"

"Select * from master where CONCAT(case(isnull(firstname) when 1 then '' else firstname end ,' ', case(isnull(lastname) when 1 then '' else lastname end) like '%" & Text1.Text & "%'"

If even then not getting success show what exact error is occurring.

wussupbuddy · #3 (**permalink**) 04-29-09, 06:23

that worked..thnx

Internet Services

Web Development

Digital Marketing

Consumer Tech