Replace Character in the column

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  September 25, 2009 at 12:38 pm

  #134109

  Hi,

  I am trying to replace the character I with 1 in one of our tables. For eg: I have a column that Registration Number for an Item = 'I23443fdd'. But the Value should be '123443fdd' (1 in place of I). there are lot of records like this...so I have to replace all the Values with I to 1.

  select * from tblRegNo where RegistrationNo like '%I%'

  I get around 1000 records. I have to replace all these with 1's. Is there any way I could get this done? Please advise me

  Thank you

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  September 25, 2009 at 1:03 pm

  #1058637

  UPDATE tblRegNo

  SET RegistrationNo = Replace(RegistrationNo, 'I', '1')

  WHERE RegistrationNo like '%I%'

  This is completed..