[dba-SQLServer] Output wizard choked

Francisco Tapia fhtapia at gmail.com
Wed May 16 15:49:56 CDT 2007


are you asking in a select statement? it would just be the same thing like
access

right(field1, n)



On 5/16/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list