>>>Hi all, i'm implementing a dinamyc filter but i'm getting error in next case:
>>>set filter to LINE_STATUS = 'INV' or LINE_STATUS = 'NQH' and (alltrim(UPPER(HOSPITAL)) == 'JFK')
>>>I need to add quotes FOR -> (LINE_STATUS='INV' OR LINE_STATUS='NQH') to let filter works in this case. Some ideas?
>>>T.I.A.
>>Better:
>>

>>TEXT TO lcFilter NOSHOW PRETEXT 15 [TEXTMERGE]
>>     (LINE_STATUS = 'INV' or LINE_STATUS = 'NQH') and alltrim(UPPER(HOSPITAL)) == 'JFK'
>>ENDTEXT
>>
>>*** or as Sergey suggested:
>>TEXT TO lcFilter NOSHOW PRETEXT 15 [TEXTMERGE]
>>     INLIST(LINE_STATUS, 'INV','NQH') and alltrim(UPPER(HOSPITAL)) == 'JFK'
>>ENDTEXT
>>

>
>I would suggest to not use filters at all <g> It's so outdated <g>

:o)
I didn't