Where exists (Fieldname, 'Fieldvalues')?

[nihhalmca]

Hi All,

Can we use where exists() on field value? if possible can you share examples.

For instance:

1. Where exists (Fieldname, 'Fieldvalue1');

2. Where exists (Fieldname, 'Fieldvalue1','Fieldvalue2');

Note: I found some thing in help like:

Exists(Employee, 'Bill') : Returns -1 (True) if the field value 'Bill' is found in the current content of the field Employee.

[sunny_talwar]

Why not use Match instead of Exists?

Where Match(Fieldname, 'Fieldvalue1','Fieldvalue2');

[maxgro]

I think Match is a better choice

if you want exists:

where exists (Fieldname, 'Fieldvalue1') or exists exists (Fieldname, 'Fieldvalue2') or .....

or you can load your values in a table

load * inline [

Values

Fieldvalue1,

Fieldvalue2

];

load

     *,

     FieldName

from

     ...

where exists (Values, FieldName);

[nihhalmca]

Hi Maxgro - Thanks for your response.

Could you attach sample document because i tried earlier and could not find any difference on this:

where exists (Fieldname, 'Fieldvalue1') or exists exists (Fieldname, 'Fieldvalue2') or .....

[marcus_sommer]

Easier would be that you provide a small example with a few inline-data which others then could be modify.

- Marcus