The answer turns out to be...a service pack/hotfix for sql server 2000. This adds a new parameter called @ansi_attachment that can be set to true. This ensures attachments aren't sent...

I should mention I'm using bulk insert.

Absolutely!

Here is the format file

________________________

8.0

15

1 SQLCHAR 0 3 "\t" 1 Areacode

2 SQLCHAR 0 7 "\t" 2 Phone

3 SQLCHAR 0 3 "\t" 3 CustCode

4 SQLCHAR 0 50 "\t" 4 CustomerName

5 SQLCHAR...

Got a new question:

What is the trick to getting bcp to export a query using a format file? Now that I have the query itself able to export - the...

Thanks to both of you! I was hoping there was a format string command - but your suggestions will take care of it.

What about if I want to take a date and turn it into this format: mmddyy

no slashes, hyphens etc.

Thanks!!

Yes - a double quote instead of two single quotes seems to have made the difference.

Also, I see from other forum discussions that you can't bcp from a temporary table,...

Yep : here is the output I get...

Copy direction must be either 'in', 'out' or 'format'.

usage: bcp {dbtable | query} {in | out | queryout | format} datafile

[-m...

Our sql server is set for windows authentication, and I thought that if you left it blank it assumed windows authentication mode.

I did try using my windows password, and I...

Thank you everyone. Once I re-wrote the fieldnames so they all matched again, everything works - no comma after 'end'.

Thanks to everyone for their help!

Thank you for pointing that out - I had actually not corrected the syntax on my field name. I will give that a try and see if it corrects the...

having the comma in or out both give me errors, two different errors, but errors.

We are soo close!! Thank you for your help!!

I don't think I need a (from tablename) statement in an update clause... 🙂

I tried adding the "end, " to the code, but I am still getting the same error. Any other ideas? Thanks!

What I have is ....

update #temploadpac set city_state = CASE WHEN Len(CityState) < 4 Then CityState

ELSE Left(CityState, Len(CityState)-3) where city_state is not null

I'm getting a...