How to select a part of the filed in SELECT??
I want to get a part in the field of table to compare with a string. But the LIKE syntax is poor efficiency. Who can give another way. thx in advance.
WHERE FIELD1 = '2008'.
But in the FIELD1 is '2008AAAA', I want to compare '2008' with the frontal 4 char.