Bind variable does not pass through to the SQL query
When I give the variable a value from integration, no rows are extracted from the SQL source. but the log says the bind variable was added.
--------------- Executing Custom Event :BefExtract ---------------
Aug-22 07:57:58:722 :: Adding String Bind Variable: STARTMONTH with value: 'JAN-23'
But when I hardcode the value in the query directly it pulls data.
Can't seem to figure out what I am doing wrong.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):