Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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;
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'.
Hi,
U can use match function wildmatch
like match(FIELDNAME,'*d*')
wildMatch(FIELDNAME,'*d*')
~kabilan k
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.