>>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.