Die Plaasvervanger () substitusie new_ text vir old_ text in 'n teks string. As instance_ num is gespesifiseer, slegs wat voorbeeld van old_ text is vervang. Andersins, elke voorkoms van old_ text is het verander na new_ text. Gebruik Plaasvervanger wanneer jy wil hê na vervang spesifieke teks, Gebruik vervang wanneer jy wil hê na vervang enige teks wat voorgekom in' n spesifieke ligging.
The SUBSTITUTE() substitutes new_text for old_text in a text string. If instance_num is specified, only that instance of old_text is replaced. Otherwise, every occurrence of old_text is changed to new_text. Use SUBSTITUTE when you want to replace specific text, use REPLACE when you want to replace any text that occurs in a specific location.