Subject: | |
From: | |
Reply To: | |
Date: | Fri, 15 Jan 1999 12:03:06 -0800 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
> Michael Hensley writes:
>
> > IF POS(HPACCOUNT,"FIRST,LNL,FPA,LNP") <> 0
>
And Glen Cole improved it with:
> Call me wacky, but my personal preference is slightly more complex:
>
> if pos( "-"+HPACCOUNT+"-", "-FIRST-LNL-FPA-LNP-" ) <> 0
>
> Thus, an account name like "IRS" would no "accidentally" qualify.
> The change from "," to "-" is just to avoid comma-overload when
> visually examining the statement.
I agree! I usually do use POS(HPACCOUNT+"/","FIRST/LNL/FPA/LNP/"); I don't
know why I didn't in my posting. (You don't need the leading delimiter,
though; just the trailing one. Unless you think it's more readable.)
---
Michael D. Hensley | mailto:[log in to unmask]
Allegro Consultants Inc. | Visit scenic http://www.allegro.com
408/252-2330 | "Support Bill of Rights Enforcement"
|
|
|