If you want to use the text from the variables within a SQL query, you do not need a JobRouter function. Simply put the variable in apostrophes. When text variables are resolved, the apostrophes are automatically disguised, so they are no longer a risk.
Example: UPDATE TABLE SET SUBJECT = 'Name: (SURNAME) ' WHERE …
If the content of the variable SURNAME was for example d'Artagnan, the apostrophe would automatically be doubled.
Result: UPDATE TABLE SET SUBJECT= 'Name: d''Artagnan' WHERE …
If your MSSQL database unicode data is recorded, you have to take Nchar or Nvarchar fields into consideration.
Example: SELECT FROM TABELLE WHERE NAME = N'Științe'
