select 3 characters

Hi I need select the first 3 characters from a table

I try this but doesn't work

"SELECT left(data,3) AS value FROM table;"

i see the left function doesn't work what is the similar function in postgresql

Thanks

CJ
-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze