Link to home
Create AccountLog in
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
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rporter45
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