>>SELECT Enroll.enrollid; >> FROM ; >> smagic!enroll; >> WHERE ( ( ( ( ( IIF(EMPTY(?vp_scheduleid),.T.,Enroll.scheduleid=(?vp_scheduleid)) ; >> AND IIF(EMPTY(?vp_programid),.T.,Enroll.programid=(?vp_programid)) ); >> AND IIF(EMPTY(?vp_startdateid),.T.,Enroll.startdateid=(?vp_startdateid)) ); >> AND IIF(EMPTY(?vp_enddateid),.T.,Enroll.enddateid=(?vp_enddateid)) ); >> AND ( EMPTY(?vp_actionid) ; >> OR Enroll.enrollid IN (SELECT enrollid FROM v_actionflag) ) ); >> AND ( EMPTY(?vp_hasflag) ; >> OR Enroll.enrollid IN (SELECT enrollid FROM v_mustflag) ) ); >> AND Enroll.enrollid NOT IN (SELECT enrollid FROM v_notflag) >>>
>vp_cClient_Account_Number = ""
>vp_cLast = "Green%"
>vp_cFirstName = ""
>vp_cMiddle = ""
>vp_cSSN = ""
>vp_cAreaCode = ""
>vp_cExchange = ""
>vp_cFour = ""
>vp_cExchange_Four = ""
If I have records starting with "GREEN", no surprise that "Green" would return 0 result. But it took me a while to realise my mistake...