Is that possible?

Hi! I have a varchar(400) field in one table and i'd like to know if it's possible to take the first characters from a given value and how to do it. Example:

select myfield from mytable where myotherfield='myvalue';

It returns for example "Hi everyone, my name is Kalamaro"

What i want is to take the first 10 (or 20, or 30, that doesn't matter) characters, and it would return "Hi everyon"

thanks! Received on Sat Feb 23 2002 - 20:37:16 CST