Posted by Richard Lynch on 04/20/05 05:30

[Connective issues may make this a duplicate post. Sorry.]

On Tue, April 19, 2005 6:25 pm, Sugimoto said:
> What I do like to do is to get first 3 letters from "loc1" column from
openart_table (MySQL).

select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table ...

--
Like Music?
http://l-i-e.com/artists.htm




--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]