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 [2010/07/09 20:08] els |
dev:sql:functions:substring [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}} | + | ====== Development: Omnidex SQL ====== |
| - | ====== Omnidex SQL Function: SUBSTRING ====== | + | ===== SQL Functions: SUBSTRING ===== |
| - | ===== Description ===== | + | ==== Description ==== |
| The SUBSTRING function returns a new character string that is a portion of another character expression. The new string begins at the specified starting point in the original expression and extends the number of characters specified in the length parameter. If the length parameter is omitted, the new string extends to the end of the original string. | The SUBSTRING function returns a new character string that is a portion of another character expression. The new string begins at the specified starting point in the original expression and extends the number of characters specified in the length parameter. If the length parameter is omitted, the new string extends to the end of the original string. | ||
| - | This function returns a C STRING datatype. | + | This function returns a STRING datatype. |
| - | ===== Syntax ===== | + | ==== Syntax ==== |
| SUBSTRING( character_expression FROM numeric_expression [ FOR numeric_expression ] ) | SUBSTRING( character_expression FROM numeric_expression [ FOR numeric_expression ] ) | ||
| Line 24: | Line 24: | ||
| If the start_no was 4 in the string above, then 's' would be the first character of the returned substring. | If the start_no was 4 in the string above, then 's' would be the first character of the returned substring. | ||
| - | ===== Example ===== | + | ==== Example ==== |
| - | ==== Example 1: Substring of column ==== | + | === Example 1: Substring of column === |
| <code> | <code> | ||
| > select name, | > select name, | ||
| Line 43: | Line 43: | ||
| </code> | </code> | ||
| - | ==== Example 2: Complex expression ==== | + | === Example 2: Complex expression === |
| <code> | <code> | ||
| The following example removes the salutation from the name. | The following example removes the salutation from the name. | ||