How to convert Float to Varchar

Mhasan · Post by **Mhasan** » Fri Sep 21, 2007 4:25 am

Hi,

Can anybody tell me how to convert float to varchar..

My input data is coming in Float datatype( sql server ) but target database oracle is it in Varchar format

us1aslam1us · Post by **us1aslam1us** » Fri Sep 21, 2007 3:56 pm

Try DecimaltoString() or StringfromDecimal() or DFloattoString().

ArndW · Post by **ArndW** » Fri Sep 21, 2007 6:21 pm

The Float to String conversion can also be done implicitly, anytime your source is float and your target is string in a stage the engine will perform an implicit conversion for you. It is better to perform explicit conversions so that you know when and how numbers are being converted, but it isn't required. The Parallel Job Developer's Guide documents which datatype conversions can be performed implicitly.