Update part of a field in a table 1

[piovesan]

Is it possible to update only part of a field in a table? I have a field called street_names which contains the street name, and street type. Ex. Connor Ct, Lahey Ct, etc But I want all the Ct s to be CRT. How can I change the street type and still maintain the proper street name?

 

[LittleSmudge]

Use

UPDATE tblTableName SET tblTableName.StreetName = Left([StreetName],Len([StreetName])-2) & "CRT"
WHERE (((tblTableName.StreetName) Like "*Ct&quot);



Replacing tblTableName with your table name - of course.


QED.

G LS

 

[piovesan]

Thanks so much!