Trim/Delete string from Table

[benjatado]

I am trying to find a way to DELETE or TRIM the word 'Track' from a column of values where the values look like:
Track 01
Track 02
Track 03... etc.

I would like to delete the word Track from this column. I am aware of the SELECT SUBSTRING(string,start_char,len) function... but I really want to permanently delete this 'Track' from all of the records in the column.

Any help would be greatly appreciated!!

-Thanks!!

 

[amrita418]

Use the replace function.

select replace('Track 234', 'Track ' , '')

Regards,
AA

 

[vongrunt]

Hard-coded example should look like:

UPDATE myTable
SET myColumn = substring(myColumn, 7, anylargeenoughnumber)
WHERE myColumn LIKE 'Track %'

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[amrita418]

I did not realise you wanted a update the table.

Use this:

update Test
set name = replace(Name, 'Track' , '')

Regards,
AA

 

[benjatado]

Thanks!
This worked like a charm!

Update TableName

Set ColumnName = replace(ColumnName, 'Value', 'New Value')

Brilliant!

I also used this to Set = LTRIM() to delete some of that annoying whitespace... works great.

Thanks!