[RESOLVED] Multiple Replace Function Order

I want to do a multiple replace on one field in a table. I want to replace apos; and ampapos;. What would the order have to be to first replace ampapos;?

Do I do replace(replace(description, 'apos;', ''''),'ampapos;', '''') or
replace(replace(description, 'ampapos;', ''''),'apos;', '''')

thank you.

replace the longer word first so you are not left with unreplaced 'amp' tokens.

Thank you. What would the replace statement look like in order to replace those first?

Try your second line of code in post #1

thank you.