search

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.73k stars 1.57k forks source link

IFNULL supported? #874

Closed devSC closed 3 years ago

devSC commented 5 years ago

How to select value like below?

SELECT firstname,
       lastname,
       IFNULL(fax, 'Call:' || phone) fax
  FROM customers
 ORDER BY firstname;

Thanks.

yacir commented 5 years ago

Any update about this request ?

jberkel commented 3 years ago

https://github.com/stephencelis/SQLite.swift/blob/master/Documentation/Index.md#core-sqlite-functions