I have an update query. In the [Roles] field there will be varying comma separated text, wich comes straight from the source.
I want to check the record email address in the one of the source tables and add new text to that [Roles]
For example, in english:
If the email ends in "jores.com" then add ",Jores Employee" to whatever is in the roles field already.
I can't get the syntax correctly in the following and keep getting errors on the word employee. I need a little help.
" & [Roles] & ",Jores Employee"),"")