I have the following table :
and on the other side I have a string that can contain words from the above table , ex: "Jeff El ABC THE DEF"
I need to do the following :
REPLACE("Jeff El ABC THE DEF", Select words from table,"");
So I need to remove any word found in the query result , any suggestions ?
Example:
input: "Jeff EL ABC THE DEF" query result : words[EL, THE, AL] expected output: "Jeff ABC DEF"