in reply to Re: Search breaks based on search string
in thread Search breaks based on search string
This script returned no values in Access, but once i removed the emp_user_name LIKE '%%' part, it ran fine:SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph +one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry ORDER + BY emp_user_name
I'm going to make a few modifications to see if i can fix it now that i have more to work with.SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph +one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry WHERE + emp_user_name LIKE '%%' AND bb_status='DEPLOYED' ORDER BY emp_user_n +ame
|
|---|