Results 1 to 15 of 15
Mar 2, 2011, 19:18 #1
- Join Date
- Jun 2010
- 0 Post(s)
- 0 Thread(s)
What would be the best where clause?
I have a control panel where the site owner can search for products by product number. It happens quite often though that they make a typo: BAR 2131G instead of BAR2131G (notice the space in the first one. Or instead of the G at the end they type a H (next to the G on the keyboard). I would like to return some alternative records in case something like that occur. What would be the best where clause in such a case? A wildcard LIKE % % or are there any other suggestions?
Thank you in advance“Good artists copy, great artists steal” (Pablo Picasso - 1934)