I have the following code
[update WALLET_SHARE.WS_1MO set TOTAL_DISP_QTY = 20.0, BX_OPP_QTY = 10.0, BX_OPP_AMT = 185.0 where GNN = ‘TETANUS &DIPHTHERIA TOX,ADULT’ and PARENT_ID = 100241164 and DISP_UNIT = ‘DOSES’;
delete from WALLET_SHARE.WS_1MO where GNN = ‘TETANUS &DIPHTHERIA TOX,ADULT’ and PARENT_ID = 100241164 and DISP_UNIT = ‘ML’;
commit]
When I try to run the first statement I get a Variables Pop-up box, The name of the GNN I’m referencing is exsactly as it is in the WS_1MO table. How do I get this statement to run when the name contains spaces, commas, and “&”?