troubleshooting Question

sql search as you type

Avatar of Richiep86
Richiep86 asked on
Microsoft SQL ServerOracle DatabaseMicrosoft SQL Server 2005
9 Comments2 Solutions368 ViewsLast Modified:
select userid, (last_name + '; ' +first_name+' ['+UPPER(userid)+']') as appr_name from zusm_approvers where general_approver = 1 and userid not in ('%USER_ID%') and (last_name+';'+first_name like '%%%usersearchspec%%%' OR last_name+'; '+first_name like '%%%usersearchspec%%%' OR last_name+';'+first_name like '%%%usersearchspec%%%' OR last_name+','+first_name like '%%%usersearchspec%%%' OR first_name+';'+last_name like '%%%usersearchspec%%%' OR first_name+'+ SPACE(1)'+last_name like '%%%usersearchspec%%%' )  ORDER BY last_name,first_name

the above does not search by first_name SPACE last_name...

Customers should be able to type their first name followed by a space to search their name.

i have tried this:

OR first_name+'+ SPACE(1)'+last_name like '%%%usersearchspec%%%'
OR first_name+' '+last_name like '%%%usersearchspec%%%'

with no luck,

Any ideas?
Saurabh Bhadauria

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros