Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:functions:home [2011/03/31 14:50]
doc
dev:sql:functions:home [2016/06/28 22:38] (current)
Line 83: Line 83:
 ====== Omnidex SQL Function Descriptions ====== ====== Omnidex SQL Function Descriptions ======
  
-|< 100% 202060% >|+|< 100% 182458% >|
 ^Function  ^Parameters  ^Description  ^ ^Function  ^Parameters  ^Description  ^
 |  ||| |  |||
 ^**String Functions**  ^^^ ^**String Functions**  ^^^
-| [[dev:sql:functions:character_length | CHAR[ACTER]_LENGTH]] |(char_expr) | Return the number of characters in a character expression. | +| [[dev:sql:functions:character_length | CHAR[ACTER]_LENGTH]] |(char_expr) | Return the number of characters in a string. | 
-| [[dev:sql:functions:lower | LOWER]] | (char_expr)|Convert all characters in a character expression to lower case. | +| [[dev:sql:functions:lower | LOWER]] | (char_expr)|Convert all characters in a string to lower case. | 
-| [[dev:sql:functions:position | POSITION]] | (search_expr IN target_expr)| Return the position of a character expression within another character expression. | +| [[dev:sql:functions:position | POSITION]] | (search_expr IN target_expr)| Return the position of a string within another string. | 
-| [[dev:sql:functions:substring | SUBSTRING]] | (char_expr FROM pos FOR len)|Return a specific part of a character expression starting at FROM position FOR length. | +| [[dev:sql:functions:substring | SUBSTRING]] | (char_expr FROM pos FOR len)|Return a part of a string starting at FROM position FOR length. | 
-| [[dev:sql:functions:trim | TRIM ]] | (['char' FROM] column)| Remove leading and/or trailing spaces or characters from a character expression. | +| [[dev:sql:functions:trim | TRIM ]] | (['char' FROM] column)| Remove leading and trailing spaces or characters from a string. | 
-| [[dev:sql:functions:upper | UPPER ]] | (column)| Convert all characters in a character expression to upper case. | +| [[dev:sql:functions:upper | UPPER ]] | (column)| Convert all characters in a string to upper case. | 
-| [[dev:sql:functions:concatenation | || (Concatenation) ]] | char_expr %%||%% char_expr | Concatenate multiple character expressions into a single character expression. | +| [[dev:sql:functions:concatenation | || (Concatenation) ]] | char_expr %%||%% char_expr | Concatenate multiple strings into a single string. | 
-| [[dev:sql:functions:lj | $LJ ]] | (char_expr) | Left justify a character expression eliminating leading white space. | +| [[dev:sql:functions:lj | $LJ ]] | (char_expr) | Left justify a string eliminating leading white space. | 
-| [[dev:sql:functions:lpad | $LPAD ]] | (char_expr, len [, pad_char ])| Add leading 'pad' characters to a character expression. | +| [[dev:sql:functions:lpad | $LPAD ]] | (char_expr, len [, pad_char ])| Add leading 'pad' characters to a string. | 
-| [[dev:sql:functions:proper | $PROPER ]] | (char_expr) | Shift the first letter of each word in a character expression to upper case and all other letters to lower case. | +| [[dev:sql:functions:proper | $PROPER ]] | (char_expr) | Upshift the first letter and downshift the rest of each word in a string. | 
-| [[dev:sql:functions:rj | $RJ ]] | (char_expr) | Right justify a character expression eliminating trailing white space. | +| [[dev:sql:functions:rj | $RJ ]] | (char_expr) | Right justify a string eliminating trailing white space. | 
-| [[dev:sql:functions:rpad | $RPAD ]] | (char_expr, len [, pad_char ])| Add trailing 'pad' characters to a character expression. |+| [[dev:sql:functions:rpad | $RPAD ]] | (char_expr, len [, pad_char ])| Add trailing 'pad' characters to a string. |
 |  ||| |  |||
 ^**Math Functions**  ^^^ ^**Math Functions**  ^^^
Line 104: Line 104:
 | [[dev:sql:functions:mod | MOD ]]  | (int_expr, divisor) | Returns the integral remainder of one integer expression divided by another. | | [[dev:sql:functions:mod | MOD ]]  | (int_expr, divisor) | Returns the integral remainder of one integer expression divided by another. |
 | [[dev:sql:functions:round | ROUND ]] | (num_expr [, digits]) | Round a numerical value to the specified number of decimal places. | | [[dev:sql:functions:round | ROUND ]] | (num_expr [, digits]) | Round a numerical value to the specified number of decimal places. |
-| [[dev:sql:functions:trunc | TRUNC ]] | (num_expr [, digits]) | Return a numeric expression truncated to a specified number of digits to the right of the decimal point. |+| [[dev:sql:functions:trunc | TRUNC ]] | (num_expr [, digits]) | Truncate a numeric expression to the right of the decimal point. |
 | [[dev:sql:functions:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. | | [[dev:sql:functions:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. |
  
 {{page>:bottom_add&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}
 
Back to top
dev/sql/functions/home.1301583011.txt.gz · Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0