Thankyou. That was very usefull.

Here is the Syntax I used:

Running from a DOS prompt:

bcp DbName.dbo.tablename out Filename.txt-Slocalhost\SQLEXPRESS -T -c

I have changed the date field from string to datetime and its much easier now.

Thanks to all for their suggestions.

Thank you to all that replied.

dcclark's suggestion really solved my issue.

All responses sent me into the right direction. The only problem  i have now is that I need to change...

Thanks both Diane and Mike but both of your suggestions failed.

Even if I simply do "...where Date >= '06/13/2006' it returns 22000 records with dates of 19/01/2001 etc.

I've checked my...