I wanted to add the @ symbol to dynamically create code like

set @strSQL = 'DECLARE @' + @VARIABLE + ' varchar(50)'

exec (@strSQL)

to create :

DECLARE @JULY varchar(50)

dynamically

This appears to work....

Why?

The same code is run again and again but for

different months.

At the top of the code I set the month

and can thus run the same code easily for the appropriate...

char(0) is a NULL.

If you go to:

http://www.asciitable.com/

you can find out what all these characters are.

duplicate deleted

Edited by - zhesley on 10/28/2003 01:40:33 AM

deleted duplicate

Edited by - zhesley on 10/27/2003 08:42:10 AM

deleted duplicate

Edited by - zhesley on 10/27/2003 08:40:30 AM

I am not 100% sure but perhaps

when DTS exports numbers it adds two extra

for a potential negative sign of the number i.e. '-'

and another for a potential decimal point i.e....

Deleted duplicate post.

Edited by - zhesley on 10/27/2003 05:30:15 AM

I found the ASCII command useful when I had a similar problem. See BOL:

ASCII, code converted to a character

BOL gives some code to loop through a text string and...

Installed a different Service Pack and bcp works fine now.

Thanks

Zoltan