How to Convert a Table Column Float Datatype to Varchar Sql

Question

Hi Developers In my sSql Database I have created one Student Marks table and inserted more than 5000 student Marks with Float Data Type Now i want to insert Text also. So how can i convert the Mark Column Float datatype to Varchar datatype. Please help me friends for i am done this task Thanking You Paul.S

Suthish Nair · Answer

Quick way is add a new varchar column copy all float data to that new column and drop float column... SELECT CAST ( CAST (floatcolumn AS DECIMAL (20)) AS VARCHAR (20))

Paul Rajs · Answer

Thanks for your Quick reply Mr.Sathish . by Paul.S