Another Report INSTR Question

[Quoted] 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 [Quoted] 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 [Quoted] 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 [Quoted] 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. Received on Tue Aug 29 2000 - 18:57:19 CEST