Stip all but first 12 characters in a table row

UPDATE <yourtablename>
SET <yourcolumnname> = LEFT(<yourcolumnname>, 12)
WHERE <some condition if required>

eg:

UPDATE tblEmployees SET EmployeeName = LEFT(EmployeeName, 12)

Select allOpen in new window

This updates 'Joseph Abraham' to 'Joseph Abr'

Raj

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

Perfect solution. Thanks.