SQL db2 remove specific item from the query Can you please help me out with the below query?
What I am looking for is a code to exclude items with wording '90003' from column COR_ID.
So far I have a code that extracts data with date older than today from column VAL_DT, excluding items with wordings MAN, NOSTRO, SCREV and SCRIN for which query shows also dates newer than today.

All I need is for the below code is to remove '90003' from column COR_ID

WHERE 
    VAL_DT &lt; CURRENT DATE AND COR_ID &lt;&gt; '90003'
    OR (   
       MVT_DS = 'NOSTRO' 
       OR MVT_DS = 'SCREV' 
       OR MVT_DS = 'SCRIN'
       OR MVT_DS = 'MAN' 
       )
Following WHERE clause shold do the job

WHERE COR_ID &lt;&gt; '90003'
  AND (VAL_DT &lt; CURRENT DATE  OR MVT_DS in ('NOSTRO', 'SCREV', 'SCRIN', 'MAN')  )