General information
Category:
Coding, syntax & commands
>I am not sure the fastest way to do this kind of search in sql server, maybe a regular expression?
>
>Let's say I have a 6 character varchar field. In that field are license plate nunbers, such as "L1 234", "QA3333", etc. Now the user enters via a telephone 6 numbers. (I cannot control the IVR portion and must deal with the 6 numbers.) Now given the phone pad, if a user enters "235466" that could really mean:
>235466
>A35466
>B35466
>C35466
>2A5466
>2B5466
>
>etc for millions of combinations. I need to pull the recordfs that match any of those possibilities.
>
>Comments?
I presume that you want search such that digit would match a digit or equivalent letter found on keypad/dial on the telephone for that digit?
1 - matches 1
2 - matches 2, A, B, C
3 - matches 3, D, E, F
4 - matches 4, G, H, I
5 - matches 5, J, K, L
6 - matches 6, M, N, O
7 - matches 7, P,Q, R, S
8 - matches 8, T, U, V
9 - matches 9, W, X, Y
0 - matches 0
note: Some phones may not have "Q" mapped to a digit on the dial/keypad
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only