I've converted my company names from ALL CAPS to Proper Case using an update query. Now I'm left with portions of records that need correcting. I want to use an update query to Find/Replace text within records such as: Find: Llc Replace with: LLC Find: Llp Replace with: LLP Any helpful hints as to how to do this using and update query. I keep replace the entire company name with LLC. I can't figure out how to properly use the correct wildcards.