Sql Stament error

I have a table with a column ( columnA) it contains the values TRTK-1234567890 I want to update the values so that TRTK becomes PMTK i tried the following and it failed:

update table
set columnA='TRTK%'
where columnA='PMTK%';

0 rows updated

argg I know this is a menial thing but just frustrating

Thanks in advance

J Received on Thu Sep 06 2001 - 13:39:10 CDT