Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
this what we are using in sql scipting while generating qvd
AND THE.CallerID NOT IN (45,67,667,288)
but i wanted to apply this filter to qvd before reload.
can anyone help me.
thanks in advance.
Hi,
you can probably use:
AND NOT Match(THE.CallerID, 45, 67, 667, 288)
- Ralf
rather use it like this: AND Match(THE.CallerID, 45, 67, 667, 288) = 0
Same result but hard to read..
Maybe this is the best option then (just found it):
AND NOT EXISTS (THE.CallerID,45,67,667,288)
Never used it myself, but will do next time I need something like that.
Regards