excluding a range in a query

• frdrckmitchell7

  Ten Centuries

  Points: 1351

  More actions

  September 17, 2013 at 4:44 am

  #297929

  Hi All

  Can someone perhaps put this in an example query please?

  exclude all "BA" items except BA00044

  Many thanks

• MD21

  SSC Rookie

  Points: 46

  More actions

  September 17, 2013 at 5:37 am

  #1650744

  Try to build your query like this

  SELECT * FROM TABLEname WHERE ColumnName='BA00044' OR ColumnName NOT LIKE 'BA%'

• frdrckmitchell7

  Ten Centuries

  Points: 1351

  More actions

  September 17, 2013 at 5:43 am

  #1650749

  Thanx GrassHopper. Really appreciate it.