This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:functions:convert [2010/07/27 22:44] els |
dev:sql:functions:convert [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
{{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
+ | |||
====== Omnidex SQL Function: $CONVERT ====== | ====== Omnidex SQL Function: $CONVERT ====== | ||
===== Description ===== | ===== Description ===== | ||
Line 39: | Line 40: | ||
|ZF |Zero-fill | | |ZF |Zero-fill | | ||
|BWZ |Blank when zero | | |BWZ |Blank when zero | | ||
- | |PAREN |Use parenthese for negatives | | ||
- | |MIN |Use minus sign for negatives | | ||
Line 60: | Line 59: | ||
</code> | </code> | ||
+ | ==== Example 2: $CONVERT with options ==== | ||
+ | |||
+ | <code> | ||
+ | > select $convert(name, 'char(50)',,'rj dns') name_rj from individuals; | ||
+ | |||
+ | NAME_RJ | ||
+ | -------------------------------------------------- | ||
+ | ms. mary lewis | ||
+ | mrs. alice r tolliver | ||
+ | mr. sidney k tolliver | ||
+ | mrs. jennifer j hopkins | ||
+ | mr. charlie hopkins | ||
+ | ms. kimberly blue | ||
+ | kathleen tucker | ||
+ | </code> | ||
====== Additional Resources ====== | ====== Additional Resources ====== |