Stip all but first 12 characters in a table row

What SQL 2000 query command can I use to strip all but the first charcters from a database table field, and affect the entire database table column, all entries?
QsorbAsked:
Who is Participating?
 
sybeCommented:
UPDATE <table> SET <field> = LEFT(<field>, 12)
0
 
Rajkumar GsSoftware EngineerCommented:
UPDATE <yourtablename>
SET <yourcolumnname> = LEFT(<yourcolumnname>, 12)
WHERE <some condition if required>

eg:
UPDATE tblEmployees SET EmployeeName = LEFT(EmployeeName, 12)

Open in new window

This updates 'Joseph Abraham' to 'Joseph Abr'

Raj
0
 
Bhavesh ShahLead AnalysistCommented:
Hi,

your Question title says

you wanted first 12 Characters.

Your details says
"
What SQL 2000 query command can I use to strip all but the first charcters from a database table field, and affect the entire database table column, all entries?
"
Means you want to remove only first char.

for first 12 Characters, experts show you answer.

if you want to remove only 1st character, i.e.

From "~This is row"
To "This is row" then

Declare @Str Varchar(30)
Set @Str = '~This is row'

Update Table
Set Value = SubString(Value,2, len(Value))



Before running it, take backup by

Select * into TableBackup from Table




0
 
QsorbAuthor Commented:
Perfect solution. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.