I am trying to run this query:
SELECT * FROM table WHERE field like '151215%0'
If I run this query:
SELECT * FROM zpartsn WHERE partSN like '151215%' and partSN like '%0'
then 2 results are returned:
151215010 & 151215020.
But when I run the first query no results are returned.
Can you assist?
|
Supported. Please download the latest package.
|