WHERE Clause in Load Script using variable

[bkn]

My requirement is to get the value in variable from the Table and use in WHERE Clause in Load Script.

Example:

'NTNAME' is a table which has value like Jack,Ryan,Anand,..

Variable vR1 stores values from NTNAME.

I need to put the NTNAME inside that variable and use that variable vR1 in WHERE Clause and need to use Wilcard '*'

=IF(WildMatch([Chain],'*$(vR1)*'),[Chain])  

Thanks in Advance.