Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hieveryvone, i'm loading a qvd file and i want to set a where clause with multiple values.
What is wrong in my statement below?
Thank you for your time.
May be try like this
Where not WildMatch(SDDCTO, 'CR', 'SR', 'UK', ......)
You cannot add multiple expressions with a logical operator,
easiest would be to use Sunny's suggestion.
Simplified you may also write
WHERE SDDCTO <> 'CR' AND SDDCTO <> 'SR' AND SDDCTO <> 'UK' etc. (analogue to the second row of your where-clause).