select if(...) from

Hello,

is it possible, with Ingres II, to write such a query :

select field1, if(field2>25,field3,field4) from table

where the syntax would be if(condition,then,else) ?

Thanks !


.

Relevant Pages

  • Text field in a group by, how can I make it work?
    ... Table1 Group By Field1. ... I think the syntax is correct, ... that Field1 is of type Text (and not varchar). ... convert this field into something else directly in the query so the query ...
    (microsoft.public.sqlserver.fulltext)
  • RE: EXISTS reserved word in FROM clause
    ... we make a good pair because I know Access SQL ... from what you described the query syntax that I ... >The subquery should return the records: ...
    (microsoft.public.access.queries)
  • Re: Few questions concerning Ingres 2006
    ... correspondence, a table that holds ... attachments to correspondences. ... formed query on a toy database that I happen to have handy (this should be ... It is quite rare that Ingres produces a bad query ...
    (comp.databases.ingres)
  • Re: Exclusive Form
    ... You're using the syntax for an UPDATE query, ... "'", dbFailOnError ... I created a new table called FormLock with one field named ...
    (microsoft.public.access.formscoding)
  • Re: Bizarre subquery syntax problem
    ... With Access, the official syntax for a subquery always requires an alias, so ... SELECT p.AS UID, p.Firstname AS Firstname, p.Lastname AS Lastname, ... I am seeing bizarre problems with a subquery. ... core query runs fine- ...
    (microsoft.public.access.queries)