please check if correct

[mATOK]

hey there, I have a column of type varchar that contains something that looks liek the following

Cat 002
Cat 002
Cat 003
Cat 005
Cat 107

etc

What I would like to do is remove the 'Cat ' from every record and be left with only the three digit number.

do I want to execute - UPDATE substring(category, 5, len(category)-4) ?

I'm pretty new to these types of commands and would apreciate confirmation / correction.

thanx

[fenway]

If it's always 3 digits, you can do the following:

UPDATE yourTable SET yourColumn = RIGHT( yourColumn, 3)

But you'd probably want to run an equivalent select query first just to be sure.

[mATOK]

Thank You! :D