General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
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
Thanks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only