Grouping a range in an IF statement

[#1]

Is there a way to group a range within an IF statement without having to list each item on its own line? I have commodity codes in a range of 5201 thru 5251 and I need to group them into T-SLEEVES. I know I can do this individually but I would rather do this in less than 50 lines if possible. Please advise.

[#2]

I will keep this in mind.

Thank you.

[#3]

When I try to use this code, the script bombs. Is it because I have IF statements that are using the WILDMATCH and I can not mix the two?

[MarcoWedel]

Hi,

your usage of

WildMatch([CommodityCode], '*5002*'

sugests, that there might be more than just those 4 numerical characters contained in your CommodityCode field.

Do you have sample data to clarify?

thanks

regards

Marco