How does one use the % SQL wildcard after a variable name in the execSQL service while using variable substitution.
Lets say you want to grab all of the rows in the Authors table where the authors name started with the variable %FirstName%.
- Assuming /FirstName = ‘Jon’
Intended SQL after variable substitution:
select * from Authors where name like ‘Jon%’
Syntax I’m using (and doesn’t work)
Select * from Authors where name like ‘%FirstName%%’
wM fails to replace %FirstName% with ‘Jon’ because of the SQL wildcard following the variable name. (The second % after FirstName.)
Thanks for the help