[dba-SQLServer] Output wizard choked

I tried to set up an export using the export wizard.  It choked because the
data in the address1 field was larger than the allowed data field width that
I entered.  The output file is a fixed width file speced by the customer so
what there is is what there is.  I saw no place to edit the transform or
tell it to go ahead and trim the data.  I did save the transform info in a
DTSX file, though the last time I did that it didn't end up very useful.

What is the SQL Server syntax for returning the first N characters?

Any suggestions.

John W. Colby
Colby Consulting
www.ColbyConsulting.com