bcp and money datatype

[Lee McCourt]

Hello!

I`ve just run into an odd problem and I`m stymied. If I bcp out a `money` field on Sql Server 4.2, it doesn`t put in the commas (1234.56). If I use the same bcp options and the same format file (except for changing the version # from 4.2 to 6.0) on 6.5, I get the commas (1,234.56).

I don`t want the commas. (really...the program that gets the data doesn`t want the commas).

I believe if I used the /c option, I wouldn`t get the commas but would be stuck with the tab delimiter (which I don`t want).

Has anyone run into this problem? Thanks for any help!

Lee McCourt

[Chuck Lucking]

Hello Lee,

Try this....
Create a View on your table converting money to float. This will eliminate your comma`s
Then BCP out from the view

Chuck

[Lee McCourt]

On 8/6/98 5:30:56 PM, Chuck Lucking wrote:
> Hello Lee,

Try this....
Create a View on your table converting money
> to float. This will eliminate your comma`s
Then BCP out from the view

Chuck

Thanks for the suggestion!! I`ll give it a try!