I am bulk inserting a file into my database that contains the column 'cost'
The column has the following values:
0.113333
0.0105
0.02178
0.040333
0.028022
I cant seem to find a data type in sql that maintains these figures they always end up
as a large
integer even when I insert them into a column with char data type.
Any suggestions
TIA
Colin Robinson
Senior Analyst Programmer
In-tuiton.co.uk
+44 1825 746400
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists