Nick77

I'm writing a script that substitutes certain words in a field for another word. i.e Substitute(Field1,"Yellow","Red") This is fine if the word is Yellow but doesn't work if it is yellow or YELLOW or any other combination of capitals and small letters. Is there a way to catch all combinations or do I need to do a SUBSTITUTE command for every combination? Regards Nick