First suggestion will work so far as you've format consistent in your field. if you happen to have other x characters inside they'll also get replaced.
so better approach might be below if your format is not consistent.
update table1
set col1='X' + STUFF(col1,1,1,'')
WHERE col1 LIKE 'x%'
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Replace one character within a field
Posted - 03/07/2013 : 06:24:58
