does CR have a "like" or "in" function like SQL does?

[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

 

[kenhamady]

see the answer in the general forum. Ken Hamady

http://www.kenhamady.com/

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

 

[emcevoy]

Hello

Yes, you can use either the like or the in operators in Crysal reports. Look up In Array Operator, In Range Operator, and in String Operator. for the like, use the search to locate the Like operator. Crystal Help on these two are quite good.

Hope this helps.
E. McEvoy
Crystal Reports Consultant

http://www.pacificridgesolutions.com

 

[gyro1107]

I have found that you can use the IN statement with Crystal reports. The trick is that you need to enclose the qualifiers in square brackets. I.E.
{PO_Custom_TextSmall1.potxt_Small02} IN ['Closed','Active']

 

[FoxG]

Hi Darwin,
you may also find little used functions called:- "lookslike" and "soundslike" in the additional functions!

 

[darwin101]

Thanks All! i have never seen lookslike or soundslike.. now i know.. ver 6.0 has soundex but not soundslike. i think we are upgrading this summer
3 months ago i knew next to nothing about CR, yesterday i completed a report with 80+ needed formulas.. but still have a great deal to learn...
Thanks again... B-)