Solved

Convert column from Varbinary(50) to Varchar(50)

Posted on 2006-11-30
2
619 Views
Last Modified: 2006-11-30
A database column that I am working with has a field that was mistakenly set to Varbinary(50) instead of Varchar(50). I changed it to Varchar(50) however now all the characters in the column have been padded with extra unknown characters. How do I fix the data in this column to remove the extra characters?
0
Comment
Question by:craigdev
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 18044674
Update urTable
SET vabinaryColumn  = cast (vabinaryColumn as Varchar(50) )
0
 
LVL 1

Author Comment

by:craigdev
ID: 18044694
thanks mate
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question