Returning the first three characters from a string
Posted: Mon Aug 01, 2005 11:41 am
Hi does anyone know how to remove the last three characters from a column with an undifined string length in SQL...
Example...
SELECT * from animals
Would currently return:- elephant,monkey,frog
I would like it to return:- eleph,mon,f
Any help will me much appreciated Ian
Example...
SELECT * from animals
Would currently return:- elephant,monkey,frog
I would like it to return:- eleph,mon,f
Any help will me much appreciated Ian