Examples of Using LIKE and NOT LIKE Operators in SBM–Processed SQL

Suppose that the Functional Area fields have possible values of Accounting, Support Operations, Development and Internal Systems:

• To find all items related to Accounting:

  "Functional Area" LIKE Accounting or "Functional Area" = Accounting

• To find all items that are related to any other functional area besides Accounting:

  "Functional Area" NOT LIKE Accounting or "Functional Area" <> Accounting

  Note: SBM–processed SQL allows only one value in each condition; you cannot use "Functional Area" <> x,y.