how to get first 20 character from mysql

[kula]

Hi,

Can you tell how to get first 20 character from mysql ?

Many thanks

Regards
Raj

[Wien]

I'm not sure I get you... You mean you want to fetch the 20 first char or a selected field

SELECT SUBSTRING(MyField, 1, 20) FROM ...

[kula]

Hi Wien

Your script works

Thank you very much wien

Regards
RAJ