I have a table with an address field. The data in this field for example is
1234 Main St.; 1234 Main Street. I want the data to be consistent, example,
all "St. Should be "Street" and "Rd" should be "Road". Can anyone please
help me with a query that will change all adresses ending with "Rd" to
"Road" and so on?

Thanks.