>Sorry my mystake, i mean the symbol ( parenthesis to let works filter that has OR and AND expressions. In my example a="set filter to LINE_STATUS = 'INV' or LINE_STATUS = 'NQH' AND claim=60814" &a <-- this doesn't work due to expression is trying to evaluate OR and AND in the same context, this will work in this way: a="set filter to (LINE_STATUS = 'INV' or LINE_STATUS = 'NQH') AND claim=60814" &a i need to find the way to add parenthesis to separate all OR instructions over AND instructions. Let OR instructions keep together. All this instruction with OR always will be together and the AND will be together.
lcFiltStat = "(LINE_STATUS='INV' OR LINE_STATUS='NQH') and alltrim(UPPER(HOSPITAL)) == 'JFK'"
or
lcFiltStat = [(LINE_STATUS='INV' OR LINE_STATUS='NQH') and alltrim(UPPER(HOSPITAL)) == 'JFK']
Set filter to &lcFiltStat
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night - Worry is the interest you pay, in advance, for a loan that you may never need to take out.