Sql Server 2005 Syntax help

I have hundreds of records in a table under a column called customerpoid. The records all start with 5500. Example 55001, 55002, 55003 and so on. I know I can do a query to show me all the records that begin with 5500 by using the following:

select * from salesorder
where som_customerpoid like '5500%'

My question is I need to rename all these records with the letter X infront of the records starting with 5500. Example X55001, X55002, X55003. I know how to update these records one by one but is there a way to update all the records beginnig with 5500 to X5500 and if so how? I am a newbie so the simplier the better.
tmaususerAsked:
Who is Participating?
 
Ephraim WangoyaCommented:

update salesorder
set som_customerpoid = 'X' + som_customerpoid
where som_customerpoid like '5500%'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.