On 4/17/2018 8:15 AM, Patrick wrote: > Dear folks, I know how to count a specific field for a value for example: > > count for name=[pinterminal] > > But what if the word pinterminal is in different positions in that field? How do I count then? I know the character $ is used, but how? > > Many thanks for answering :) >
count for name $ pinterminal
// note that this is usually case-sensitive, so:
count for lower(name) $ lower( pinterminal )
This is assuming you are using dBL. If you are using SQL:
select count(pinterminal) where pinterminal like "%name%"
(The above is off the top of my head, not having your data, etc.)