FYI - the method I came up with was to search for a Unicode character value > 10000. I think the Chinese characters start around 12000.

OK - thx guys - your comments noted - I'm going to put this one to bed.

Cheers

If you have some working code that would be great.

Is something that someone here asked if it is possible to do.  I thought I would check it out, and its probably possible to write it in some long winded...

That did the trick.

Cheers

Hi

One slight problem is that any fields that have a zero length char string are output as a space.  I need this to not have a space.

Any Ideas

Cheers

Nickie

Fantastic answer.  This is exactly the problem whereby the SQL server service was using a local admin account.  It now uses a domain account.

Thanks for you answer.

Cheers

Nickie

The bcp command I used was

SELECT @FileName = 'C:\systemwatch' + CONVERT(VARCHAR(11),GETDATE(),112) + '.csv'

SET @bcpCommand = 'bcp "my select statement" queryout "'

SET @bcpCommand = @bcpCommand + @FileName + '" -ST6SQL -T...

Hi

I managed to get this set up and working using Jeffs BCP suggestion.  I want to also try Jeffs OSQL method, but as usual other things get shoved up the...

Great - I have to leave work now - i may try later on from home, or first thing tomorrow, but i will let you know how i get on.

Thanks...

Good stuff - at least its not just me going mad.  Just need to find a work around now.

Cheers

Nickie

Firstly - Thanks for everybody's help/input

The first couple of rows returns

0x530059005300570048004F00530050000000000000000000000000000000

0x330031003100320036003400480000000000000000000000000000000000

I've tried this as a dts to textfile and it works ok e.g. all columns dont have trailing spaces.  I...

Hi

And just to add to my excitement - I tried running this as a DTS package and there are no trailing spaces.  Aaarrggghhh.

Only trouble is I need it to output...

Hi

It still doesn't trim

Cheers

Nickie

OK - did that but have the same results - i've tried using set ansi_padding off etc but to no avail.  Anything else I should try on my server.