How to search in concatenated fields

[#1]

Dear all,

hope you can help me.

I want to search for values in a concatenated field. Please see example below:

How can I search for all Customer IDs, which have a 'd' within the field value? I need a function like 'contain' in Excel.

Many thanks!

[Anonymous]

If you want to search in a listbox, use *d*.

If you want to use a where clause or something in a load statement you can use where index(FIELDNAME, 'd')>0;

[#3]

Thanks for your quick answer.

I want to search at the QV desktop. If I use the listbox to select *d* I only get those data records where *d* is the only value, but not those, which contain e. g. 'a, b, d'.

[#4]

Hi,

U can use match function wildmatch

like match(FIELDNAME,'*d*')

       wildMatch(FIELDNAME,'*d*')

~kabilan k

[#5]

Hm, I want to allow users to search freely within this field. For example they could search for all customers with a and d in the field value, or for b and c.....

I hope you understand what I mean.