Parameters is not reading properly because of Static text of single quote? Can you please post how you defined the variable with SET and LET?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful