NOT LIKE Syntax

[jfokas]

I am having a problem adding one phrase to an existing formula, but I can't seem to get the syntax right. The solution is bound to be obvious that it's jut not coming to me. Please help!

The exist formula is this:

IF {stpc_slide_labels.accession_no} LIKE 'EL*'THEN{stpc_slide_labels.last_name}
ELSE{@full_name}

I'm trying to add a clause as such:

IF {stpc_slide_labels.accession_no} LIKE 'EL*' AND {stpc_slide_labels.procedure_code} NOT LIKE 'SS*' THEN{stpc_slide_labels.last_name}
ELSE{@full_name}

Crystal does not like my "NOT LIKE" statement and I can't seem to get the right syntax. This feels like an extremely silly and simple question but I'm stumped. Thanks in advance for your help!

John

 

[mbarron]

Crystal likes the NOTs in paerens:

Your formula would be:

IF {stpc_slide_labels.accession_no} LIKE 'EL*' AND NOT({stpc_slide_labels.procedure_code} LIKE 'SS*') THEN{stpc_slide_labels.last_name}
ELSE{@full_name}




Mike

 

[jfokas]

Thanks, I knew I was missing the obvious!