bcp out text

what happens to text columns when they get bcp'ed out?

Truncated to 8000?

Going csv

The project from hell...the "developer" knew access...thought text was Access text...painful...

I'll be finding out soon I guess...any comments (sympathy) appreciated...

Cross post!No - you will be ok.|||Well, I'll be doing it today...let you know what happens...

REQ:

Search every column in every table...find reference to keyword "x", then dump those rows out...

painful|||My Sympathies ...

But tell me .. how did this requirement crop up ...
would love to hear the story behind this one :)

BTW ... am working on converting some ABAP code into stored procs ... and believe me ... i am forced to use cursors :(|||Inheritance...like I got the app to support and it's a piece of garbage...

Someone knew Access, and things got out of control...

Isn't that always the case?