When we import Excel data into SQL table it will create columns with 'Float' data type.
Here is the little trikey to convert float value to varchar/nvarchar
select top 1 convert(varchar,cast(floatNumber as decimal)) n from dbo.Mytable
Showing posts with label convert float to varchar nvarchar. Show all posts
Showing posts with label convert float to varchar nvarchar. Show all posts
Wednesday, December 16, 2009
Subscribe to:
Posts (Atom)