trim field

[Anon]

what do i need to do to trim a result field?
ie. i want the 'name' field restricted to 20 characters.
cheers
gan

[ace21]

here is an exmple

select substring(name,0,20) from tblNames

0 beng the start position and 20 being the length of the string you want returned. Hope this helps.

Ace21