Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have to put a condition on a field:
the sql looks like this:
upper(pp.name) like '%PARCHETUL%' OR upper(pp.name) like '%PREFECT%' OR......
how can this conditions be implemented into a expression from a table.
The only functions I have found are: left() right() mid()...but this can't be used...
Help me please in this small problem.
Thank you in advance!
Silviu
I think the function you are looking for is wildmatch. It would work something like:
Expression Definition:
= IF(wildmatch(name field, '*PARCHETUL*','*PREFECT*',etc...),1,0) or whatever you want to display for the expression when you find a match or not rather than the 1 and 0.
Wildmatch returns true for each string found. The * is the equivalent of the % in sql.
thank you!
I will try to use wildmatch. Hope it works.
good day,
Silviu