troubleshooting Question

sql search as you type

Avatar of Richiep86
Richiep86 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008SQL
8 Comments1 Solution242 ViewsLast Modified:
this is a search as you type statement...

Currently, the system auto-selects the first result returned, if I try to enter “smith”, the system defaults to arrowsmith as that’s the first result returned.

Can i prevent this from happening?


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

THanks
ASKER CERTIFIED SOLUTION
gavsmith

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

Join our community to see this answer!
Unlock 1 Answer and 8 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 1 Answer and 8 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