Thread: Copy From 1 field to another minus first 2 characters

Hey
I have a table which has a field which has a keyword (eg: KW....)

Now i have to add a field in this table which should have the same value as in Keyword field but without first two characters KW.

This query will copy the Keyword field to other field.

Code:

update tblTable set Keyword1 = Keyword

But how to remove the first 2 characters??

Any ideas?
Thanx

MS SQL 2000

something like this:

Code:

UPDATE tblTable SET Keyword1 = substring(Keyword,3,len(Keyword))

Perfect, Thanx Mehere