Filters on SELECT

sarahzhou — Fri, 25 Feb 2022 02:09:09 GMT

The line in the selection

where MEMBER_ID = %str(&USER_NAME.) OR EMAIL_ID = %str(&USER_EMAIL.) OR (OTH_ID = %str(&OTHER_ID.) &USER_BIRTHDAY.

What is &USER_BIRTHDAY. doing? Because here I didn't see it comparing with anything.

Kindly help.

Thank you.

Re: Filters on SELECT

SASKiwi — Fri, 25 Feb 2022 02:26:58 GMT

Until we know what &USER_BIRTHDAY. resolves to we would have no idea.

Try this to find out:

%put USER_BIRTHDAY = &USER_BIRTHDAY.;