Replace proper Ucase text with lcase when word like "and", "or&q 1

[DanScott]

I have a Table with a text field that has been properized, but I need to Properize (lowercase) or run a second function that will make these certain words all lowercase. I have created a table that list "oldtext" and "newtext" (example "Or" and "OR&quot all I want to do is look thru the text field for the word in "oldtext" and replace it with "newtext". I have had no success up to now. I am sending the function the data via a SQL update statement attached to a button. Any help in making this function work properly is greatly appreciated or is there some other way to make this happen.

Dan

 

[cmmrfrds]

Try this select and if it works then turn it into an update.

select Replace(fieldname,oldtext,newtext) from table