Results 1 to 2 of 2
Thread: select character
Nov 19, 2009, 21:56 #1
- Join Date
- Sep 2004
- 0 Post(s)
- 0 Thread(s)
If I want to use a query to do matching for second character in a column, how should I go about to get this done?
E.g : I want so search which records has 8 as second character of the entry in a table.
Then it will show the results for 1881 and 2899 since both has the character in the second position.
I tried to use substr function but it is not working. Please advise and thanks.