apple
08-06-2007, 07:01 PM
HI,
Please do advise me how to write SQL to limit the
pattern number: Y1234-87498. (In front 5 digit and 5 digit at the back).
Is it i must use LEFT or RIGHT? Can anybody show me the way.
Example i used but syntax error in right
SELECT*
FROM TABLE1 COLUMNA
WHERE LEN (TABLE1.COLUMNA)= 11
AND RIGHT TABLE1.COLUMNA IN ('6')
Please do advise me how to write SQL to limit the
pattern number: Y1234-87498. (In front 5 digit and 5 digit at the back).
Is it i must use LEFT or RIGHT? Can anybody show me the way.
Example i used but syntax error in right
SELECT*
FROM TABLE1 COLUMNA
WHERE LEN (TABLE1.COLUMNA)= 11
AND RIGHT TABLE1.COLUMNA IN ('6')