Solved

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

Posted on 2006-11-30
2
586 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Connection (Error 18456) 14 34
SQL Script to find duplicates 16 19
Copy Database Wizard Error 3 21
Change part of a string 2 23
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now