ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-24
Search Conditions
For information about year to fraction data, see the NonStop SQL/MP Reference
Manual.
Converting a Character Column Value to a Datetime Value
When converting a character column value to a datetime value, the format of the data
in the column must be year to fraction 3. For example, if the START_DATE column in
the following example is a character field, the data must be in the form year to fraction
3 (such as “1994-01-05:12:29:00.123”).
select {fn convert (table1.start_date,timestamp)} ...
Blank Padding of Character Data
When you convert a character expression to character data of a longer size, the value
is blank-padded on the right.
Truncating Significant Digits
When converting between types with a different number of decimal points, the value is
truncated if trailing significant digits will be lost. If, however, leading significant digits
will be lost, an error message is issued and the statement does not execute.
Search Conditions
Use CORE SQL syntax in search conditions when using the NonStop ODBC Server.
All supported search conditions work the same as in CORE SQL.
The syntax of a search condition is any of the following:
expression-1 comparison-operator { expression-2 }
{ (subquery) }
expression-1 [ NOT ] BETWEEN expression-2
AND expression-3
expression comparison-operator { ANY } ( subquery )
{ ALL }
expression [ NOT ] IN ( { value-list } )
{ subquery }
[ NOT ] column-name [ NOT ] LIKE "match-string"
[ NOT ] column-name IS [ NOT ] NULL
[ NOT ] EXISTS ( subquery )
boolean-expression
expression { AND } expression
{ OR }