Progress
SQL-92
Guide and Reference


EXPRESSION (expr)

SYNTAX
expr ::=
[ { table_name.| alias.}] column_name
  |  character_literal
  |  numeric_literal
  |  date-time_literal
  |  aggregate_function
  |  scalar_function
  |  numeric_arith_expr
  |  date_arith_expr
  |  conditional_expr
  |  (expr) 

NUMERIC ARITHMETIC EXPRESSION

SYNTAX
numeric_arith_expr ::=
[ + | - ] { numeric_literal | numeric_expr }
  [ { + | - | * | / } numeric_arith_expr ] 

DATE ARITHMETIC EXPRESSION

SYNTAX
date_arith_expr ::=
date_time_expr { + | - } int_expr 
  | date_time_expr - date_time_expr  


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095