Re: Another Report INSTR Question

Try something like
InStr( Translate( StringToSearch, SearchLettersString, '$$$$' ), '$' )

Regards,
Aleksandr Kononov

In article <8ogq11$l84$1_at_nnrp1.deja.com>,   perkinsdt_at_my-deja.com wrote:
> Is there a way to concatenate a list of letters to search for in the
> INSTR built-in: LIKE
>
> INSTR('String to search','P',|G',|X',|S',|T',',1) where if any of the
> group shows up in string to search it will return a pos number. I can
> do this with a INSTR search for each incidence, however, I would like
 to
> put them all in one line, can this be done?
>
> The problem is the user can enter a list of JONs and if the first
> postiton of the JON is either of the above letters it is an indirect
 and
> can stand alone where any other starting letter has to be related to a
> CON. If any of the JONs are indirect the JON layout will be called
> without a relationship. If none of the indirect JONs are found the
 JON
> layout will be called with the CON relationship.
>
> Thanks,
> Diane
> perkinsdt_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 31 2000 - 10:10:06 CEST