Avatar of rporter45
rporter45
 asked on

Startswith in Crystal

Hi there,
I'd like to consolidate my coding and currently have:

or Not Isnull ({CnGf_1AttrCat_1.CnGf_1AttrCat_1_Import_ID})
and {CnGf_1AttrCat_1.CnGf_1AttrCat_1_Comments} startswith "K12-"
or Not Isnull ({CnGf_1AttrCat_1.CnGf_1AttrCat_1_Import_ID})
and {CnGf_1AttrCat_1.CnGf_1AttrCat_1_Comments} startswith "K17-"
or Not Isnull ({CnGf_1AttrCat_1.CnGf_1AttrCat_1_Import_ID})
and {CnGf_1AttrCat_1.CnGf_1AttrCat_1_Comments} startswith "K18-"

Is there are something similar to the "in" function that will allow me to say
Not Isnull ({CnGf_1AttrCat_1.CnGf_1AttrCat_1_Import_ID})
and {CnGf_1AttrCat_1.CnGf_1AttrCat_1_Comments} in (startswith ["K12-" , "K17", "K18"]) just to consolidate it to make it easier for future reference?

Thanks in advance,
CS
Crystal Reports

Avatar of undefined
Last Comment
rporter45

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ido Millet

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rporter45

ASKER
Now that sounds better! I will try and get back to you - I have been staring at this way too long,

take care,
CS
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23