This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:text:home [2011/04/17 01:05] admin |
dev:sql:functions:text:home [2012/10/26 15:00] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ^**String Functions** ^^^ | + | |**Omnidex Text Functions** ||| |
| - | | [[dev:sql:functions:character_length | CHAR[ACTER]_LENGTH]] |(char_expr) | Return the number of characters in a character expression. | | + | |[[dev:sql:functions:contains:home|$CONTAINS]] ||| |
| - | | [[dev:sql:functions:lower | LOWER]] | (char_expr)|Convert all characters in a character expression to lower case. | | + | |[[dev:sql:functions:context:home|$CONTEXT]] ||| |
| - | | [[dev:sql:functions:position | POSITION]] | (search_expr IN target_expr)| Return the position of a character expression within another character expression. | | + | |[[dev:sql:functions:highlight_criteria:home|$HIGHLIGHT_CRITERIA]] ||| |
| - | | [[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:highlight_keywords:home|$HIGHLIGHT_KEYWORDS]] ||| |
| - | | [[dev:sql:functions:trim | TRIM ]] | (['char' FROM] column)| Remove leading and/or trailing spaces or characters from a character expression. | | + | |[[dev:sql:functions:lookup:home|$LOOKUP]] ||| |
| - | | [[dev:sql:functions:upper | UPPER ]] | (column)| Convert all characters in a character expression to upper case. | | + | |[[dev:sql:functions:retrieve_file|$RETRIEVE_FILE]] ||| |
| - | | [[dev:sql:functions:concatenation | || (Concatenation) ]] | char_expr %%||%% char_expr | Concatenate multiple character expressions into a single character expression. | | + | |[[dev:sql:functions:score|$SCORE]] ||| |
| - | | [[dev:sql:functions:lj | $LJ ]] | (char_expr) | Left justify a character expression eliminating leading white space. | | + | |[[dev:sql:functions:soundex|$SOUNDEX]] ||| |
| - | | [[dev:sql:functions:lpad | $LPAD ]] | (char_expr, len [, pad_char ])| Add leading 'pad' characters to a character expression. | | + | |------------------------------|-----------------------------------------------|----------------------------------------------------------------------------------------------------------| ||| |
| - | | [[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:rj | $RJ ]] | (char_expr) | Right justify a character expression eliminating trailing white space. | | + | |
| - | | [[dev:sql:functions:rpad | $RPAD ]] | (char_expr, len [, pad_char ])| Add trailing 'pad' characters to a character expression. | | + | |
| - | | ||| | + | |
| - | ^**Math Functions** ^^^ | + | |
| - | | [[dev:sql:functions:abs | ABS ]] | (num_expr) | Returns the absolute value of a numeric expression. | | + | |
| - | | [[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: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:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. | | + | |
| - | |--------------------------------------|-----------------------------------------------|----------------------------------------------------------------------------------------------------------| ||| | + | |