Hi All,

Thanks for the replies and suggestions. I was working down the cursor / bcp route myself. It works a charm - here's a summary FYI.

DECLARE @id int,

 @bcpJob varchar(2000),

 @FileName varchar(2000)

DECLARE...

Doh!

The problem is that being an Aussie we use a different locale to the standard install. We edited the noise.eng file and...