print/return only the first X chars of a varchar column?

Hi all;

I'm selecting from a table that has a varchar(1000) but I only want to display
the firs 20 characters.  Looked at the string functions in the docs but nothing
jumped out...

Suggestions?


Thanks in advance