This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:substring [2009/12/06 22:41] tdo |
dev:sql:functions:substring [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 31: | Line 31: | ||
| ==== Example 1: Substring of column ==== | ==== Example 1: Substring of column ==== | ||
| <code SQL> | <code SQL> | ||
| - | select product_no, | + | > select product_no, |
| SUBSTRING(PRODUCTS.PRODUCT_NO FROM 2 FOR 3) as Sub1, | SUBSTRING(PRODUCTS.PRODUCT_NO FROM 2 FOR 3) as Sub1, | ||
| SUBSTRING(PRODUCTS.PRODUCT_NO FROM 5) as Sub2 | SUBSTRING(PRODUCTS.PRODUCT_NO FROM 5) as Sub2 | ||
| Line 42: | Line 42: | ||
| </code> | </code> | ||
| ==== Example 2: Substring of 'string' ==== | ==== Example 2: Substring of 'string' ==== | ||
| - | <code> | + | <code SQL> |
| > SELECT SUBSTRING ('My String' from 4) from $omnidex | > SELECT SUBSTRING ('My String' from 4) from $omnidex | ||