This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:functions:convert [2009/12/05 01:01] tdo created |
dev:sql:functions:convert [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 27: | Line 27: | ||
| ===== Example ===== | ===== Example ===== | ||
| ==== Example 1 ==== | ==== Example 1 ==== | ||
| + | <code SQL> | ||
| + | SELECT PRODUCTS.PRODUCT_NAME, | ||
| + | $CONVERT(PRODUCTS.COST,'C STRING',32,'PICTURE"$^^^,^^^,^^^.^^"') | ||
| + | FROM PRODUCTS | ||
| + | |||
| + | </code> | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||