Select Rows Using the where Clause

The general format is:

select select_list 
     from table_list 
     where search_conditions

Search conditions, or qualifications, in the where clause include:

• Comparison operators (=, <, >, and so on)

  where advance * 2 > total_sales * price 

• Ranges (between and not between)

  where total_sales between 4095 and 12000 

• Lists (in, not in)

  where state in ("CA", "IN", "MD")

• Character matches (like and not like)

  where phone not like "415%" 

• Unknown values (is null and is not null)

  where advance is null

• Combinations of search conditions (and, or)

  where advance < 5000 or total_sales between 2000
    and 2500 

The where keyword can also introduce:

• Join conditions

• Subqueries

  Note: The only where condition that you can use on text columns is like (or not like).

SAP ASE does not necessarily evaluate and execute predicates in left-to-right order. Instead, SAP ASE can evaluate and execute predicates in any order. For example, for this query:

where x != 0 and y = 10 or z = 100