How to load a value with , into a real type

#1

I have a tab delimited text file and I am trying to load that into a
table with a real data type.

Appears when it finds a value like 22,579.59 the load fails that
cannot convert to real.

Thanks
Karen

#2

do a replace
replace(value,',','')

http://sqlservercode.blogspot.com/

"karenmiddleol (AT) yahoo (DOT) com" wrote:

Quote:

I have a tab delimited text file and I am trying to load that into a
table with a real data type.

Appears when it finds a value like 22,579.59 the load fails that
cannot convert to real.

Thanks
Karen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to load a value with , into a real type

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to load a value with , into a real type - 10-19-2005 , 09:02 AM

RE: How to load a value with , into a real type - 10-19-2005 , 10:16 AM