I am inserting values of type ' $5.99' (or trying to insert) into the field money. he doesn't like the dollar sign
I actually do a bulk insert from a csv file. one of the columns in the csv file has moneya dollar sign in it
Could you help me figure out how to make this volumetric insert with a mark $in the box money?
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 2 (pricepaid).
how can i get rid of the sign?
source
share