Can we use like in the where clause ? If I put orderno = '12345' it works. When I put orderno like '1234%' it does not work it says no records found
Nathalie - You will want to use MATCHES for your where clause. Matches works against strings, so for integers, you will have to convert to string. Also replace % with *oeeh.cono = 1000 and string(oeeh.orderno) matches '1234*'
wow thks Brandon, it works
Brandon, if instead I don't want the orderno ending with 34, what do I use ?
I think the below would work, as the where clause, for that scenario."oeeh.cono = 1000 AND string(oeeh.orderno) MATCHES '^(?!.*34).1234*.*$'"
thks I will try this
