Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I count words which have the same first three characters (e.g. in SQL "abc%" )
using if statement maybe!
Count(Distinct Left(FIELD,3))
like this
if(left(Field,3)='abc',count(field))
Or may be this:
Count({<Field = {'abc*'}>} Field)
Hi Mohammed,
IF(Wildmatch(Field,'abc*'),Count(Field))
sunindia has given the best performing expression.
thanks a lot it's working
you welcome
Regards!
if you find the right answer could close the thread please
Regards.
from where i can close the threat i don't know how.
Best Regards.