SQl help please

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  May 11, 2015 at 1:46 pm

  #398441

  I have 2 requirements

  1.) Fetch the records where Charge_Capture_Primary_Code != '00550'

  2.) Fetch the records where Charge_Capture_Primary_Cod not in the range 00560-00580

  Select top 100 * FROM TBL where Charge_Capture_Primary_Code not in ( '00550 ' )

• pietlinden

  SSC Guru

  Points: 63594

  More actions

  May 11, 2015 at 1:55 pm

  #1797089

  One option...

  SELECT *

  FROM tbl

  WHERE Change_Capture_Code !='00550'

  AND Change_Capture_Code NOT BETWEEN '00560' AND '00580';