07-22-2013 11:15 AM - edited 03-14-2019 12:06 PM
Good afternoon everyone
Could you please advise me on this question? I need to search a person's information by using first 4 of ID number, first 3 of area code and another data such as his/ her birthday...
My script is....
1. Ask a caller to enter first 4 digit of ID (Complete ID number is 10digits or longer)
2. Ask a caller to enter first 3 numbers of area code
3. then, ask his/her to enter complete birthday (MM/DD/YYYY)
4. With those information, I need database to search person's recent activity data
I tired for first 4 digit ID search as SELECT * From VW_Database WHERE CustomeNumb LIKE 'CustomerNumber%' in DB Read Field Selection. However, it comes back as no data found... It does not look like taking wild card (%)
Please advise how i can use wildcards with this data search....
Thank you ,
Nana
Solved! Go to Solution.
07-22-2013 11:18 AM
You need a dollar sign in front of the variable name, when referencing script variables in SQL statements.
E.g., '$CusomterNumber%'
Could you give that a try?
Anthony Holloway
Please use the star ratings to help drive great content to the top of searches.
07-22-2013 11:18 AM
You need a dollar sign in front of the variable name, when referencing script variables in SQL statements.
E.g., '$CusomterNumber%'
Could you give that a try?
Anthony Holloway
Please use the star ratings to help drive great content to the top of searches.
07-22-2013 01:04 PM
Thank you so much for super quick reply.
My team member Left function LEFT (CsuomterNum, 4) = $CustomerNumber and yes, it worked
Thank YOU for your help as usual!!!!
nana
07-22-2013 01:14 PM
You are welcome. Glad you have it working now. Could you please mark the thread as answered? Thank you.
Anthony Holloway
Please use the star ratings to help drive great content to the top of searches.
07-23-2013 07:00 AM
Yes, Thank you so much Anthony
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: