Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Data in Column

Status
Not open for further replies.
skippaNH

skippaNH

Technical User
Aug 1, 2001
18
US
Hi all,

Is there an easy way to change the data in a column using T-SQL to simply add a zero in front of the existing value? For example, the value is 123456, but I need it to be 0123467. The column is char type, lenght of 7.

Thanks in advance :)
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
894
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
875
BobSuruncle
BobSuruncle
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
587
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
860
SashaBuilder3
SashaBuilder3

Part and Inventory Search

Sponsor

Back
Top