How to select 1st 20 characters of a field using T-SQL

[D]

I tried using the LEFT function against one of our servers to retrieve
the 1st 20 characters of a column per record. Can someone tell me how I
can accomplish extracting only the 1st 20 characters of a field per
record? The field contains about 300+ characters, but I only need the
1st 20. Thanks!

[Fábio Pinheiro]

select substring(field1,1,20) from table

D escreveu:

[D]

Thank you...this worked perfect :)