[dba-SQLServer] Output wizard choked

Yep.  I am actually using Left().  Thanks.

Now I can't get the output wizard to allow me to edit the field widths for a
fixed width output.  

I do so love this stuff.

Time to get past the wizards I suppose.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Wednesday, May 16, 2007 4:50 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Output wizard choked

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...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com