Tuesday, March 20, 2012

can this be done?

Are you able to change one word in a field without changing the whole field? I've got lots of records that are St. ?, St. Andrew's, St Jude's, ect. Can I run a query that will change the "St." to "Saint" but not change the rest of the name?
Thanks for your help.
RobI hope This Code will helps u

Update TableName Set FieldName='Sait'+
SubString(FieldName,4,len(RName))|||You can use REPLACE()

UPDATE TableName Set FieldName = REPLACE (FieldName,'St.','Saint')

Hope This helps You.sql

No comments:

Post a Comment