>>>I'm using bcp to copy some data to a csv file.
>>>
>>>Phone numbers which have been entered without a space are losing their leading zero.
>>>
>>>Whats the best way to stop happening.
>>>
>>>Phone numbers with an embedded space are ok
>>>
>>>so 07887734045 comes out as 7887734045
>>>
>>>07995 634910 comes out correctly
>>>
>>
>>Going from memory, I think you need to format the column as character instead of nuimeric in the CSV file. You can do that with Excel.
>>
>>You sure are immersed in SQL Server. How did this come about? It's going to look good on your resume. Sorry, your CV ;-)
>
>Hi Mike
>
>change of work.
>
>Funnily enough related to earlier conversation its a relatively low paid contract but I needed something quickly after the old work went tits up.
>
>main problem is the culture is like stepping back 20 years. Lots of "lets document all our processes" and its hard to get anything done quickly.
>
>Plus they are using a package and you can't write into the database without the package provider signing off your code (which costs) otherwise you void your warranty.
>
>Without opening the flame avalanche that seems to be round here at the moment I hope things are going a little better for you.

On a personal level things are going better. Now all I need is a job.