select_item

version 11

arithmetic_expression [[AS] {sql_string |sql_name}]

A select_item specifies one or more items to be included in the results. A column is generated for every select_item passed. Each select_item consists of an arithmetic_expression. You can also pass the optional AS keyword to specify the optional sql_string or sql_name to be given to the column. (Passing the optional sql_string or sql_name without the AS keyword has the same effect).

Here is an example which creates a column named Movie_Year containing movies released in the year 2000 or more recently:

   ARRAY INTEGER(aMovieYear;0)
   Begin SQL
      SELECT Year_of_Movie AS Movie_Year
      FROM MOVIES
      WHERE Movie_Year >= 2000
      ORDER BY 1
      INTO :aMovieYear;
   End SQL

arithmetic_expression, SELECT, sql_name, sql_string.