is there "IN or Like" available in CR6.0? 1

[darwin101]

i am looking for a method to compare the numeric value of a column to a list of known numbers. Does CR have something similar to oracle's sql (the "IN" or "LIKE&quot
such as

If (column) in ('1234','2345','3456') then
"bob's your uncle"
elseif (column) in ('9876','8765','7845') then
"bob's your aunt"
else
nothing

Thanks

ps.. is there a notNUll in cr?

 

[kenhamady]

Yes, they are in the operator list:

IN can be used for ranges:

{field} in 5 to 50


or for lists:
{field} in [12,24,36,48]


If you use the select expert for "One Of" or "Between" you can hit the "Show Formula" button and see the syntax.

Like is used for wild Cards in character strings. You can also demonstrate this in the select expert. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[kenhamady]

There is an IsNull() function, and you can say:

not IsNull({field}) Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)