Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to Convert a Table Column Float Datatype to Varchar Sql

Home
Forums
Learn iOS Programming

How to Convert a Table Column Float Datatype to Varchar Sql

Paul Rajs

Paul Rajs

10yAsked Jul 18, 2016, 5:46 AM960Learn iOS Programming

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Suthish Nair10y ago
Accepted 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 Rajs10y ago
Thanks for your Quick reply Mr.Sathish .
by
Paul.S