Wilcard Formula

[rickdunna]

I need to create a formula that can perform a wild card like ("0120%":

If <Account> Starts with "0102" then "New Account" Else if
<Account> Starts with "1233" then "Old Account"

I have tried several methods, but they are acting more like a filter then delivering the desired results.

I am currently working on it using the Substr()

Please advise me the best way to handle this.

This is BO 6.5

Thanks Rick

 

[dgillz]

Is this BO or Crystal Reports?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[rickdunna]

I thought I forgot, but check the thread. It is BO 6.5.

 

[lbass]

This is not a BO forum, but a BO Crystal Reports forum.

-LB