History for
Home
(history as of 8/5/2010 8:40:20 PM)
XLeratorDB/strings
Use XLeratorDB/strings for a wide variety of string manipulations. The feature-rich XLeratorDB strings function library lets you include text manipulations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.
XLeratorDB/strings requires Microsoft SQL Server® 2005 or later (which must be purchased separately). XLeratorDB/strings installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/strings.
| Function Reference - Excel String Functions |
| CLEAN |
clean non-printable characters text |
| CONCAT |
concatenate two text strings with an optional joiner |
| DOLLAR |
converts a number to text with a currency format |
| EXACT |
returns whether two strings are equal |
| FIND |
finds one text value within another |
| FIXED |
formats a number as text with a fixed number of decimals |
| PROPER |
capitalizes the first letter of each word in a text string |
| SUBSTITUTE |
replaces specified instances of text in a text string |
| TEXT |
formats a number according to excel format styles |
| TRIM |
trims leading and trailing spaces from a text string |
| VALUE |
converts text to a number (float) |
|
|
Function Reference - Additional String Functions
|
| CONTAINSSTR |
returns whether a text string contains another text string |
| COUNTSTRING |
returns the number of occurences of one string within another |
| CRLF |
returns the ascii carriage return-line feed |
| DEC2FRAC |
returns a text representation of a decimal converted to a fraction |
| ENDSWITH |
returns whether a text string ends with another text string |
| FORMATDATE |
formats a date according to Microsoft DOTNET formatting standards |
| FORMATNUM |
formats a number according to Microsoft DOTNET formatting standards |
| FRAC2DEC |
inverse of DEC2FRAC, converts a text representation of a fraction to a decimal number |
| IIFSTR |
returns one of two strings depending on a boolean condition |
| INDENT |
indents a text string to a specified number of levels with a specified indentation character. works with multi-line text. |
| INSTR |
returns the first character position of one text string within another |
| INSTRREV |
returns the character position of the last instance of one text string within another. |
| ISALPHA |
returns whether a text string contains only alphabetic characters |
| ISNUMERIC |
returns whether a text string represents a number |
| JOINSTR |
returns the concatenation of columnar data from a table or view |
| JOINSTR_q |
returns the concatenation of columnar data from a query |
| NUMWORDS |
returns the number of items delimeted by one or more separators |
| PADLEFT |
pads text to a specified width using a padding cahracter to the left of the original text |
| PADRIGHT |
pads text to a specified width using a padding cahracter to the right of the original text |
| PARSE |
returns the requested instance of an item delimited by one or more separators |
| PCT2FRAC |
converts a given percentage value to a text representation of a fraction. |
| QUOTED |
returns text surrounded with a double quote character |
| QUOTES |
returns text surrounded with a single quote character |
| STARTSWITH |
returns whether a text string starts with another text string |
| STRIP |
strips all punctuation from the beginning and end of a text string |
|
|
Function Reference - Date Functions
|
| NETWORKDAYS |
returns the number of working days (non weekend or holiday) between two dates |
| NETWORKDAYS_q |
returns the number of working days (non weekend or holiday) between two dates |
| WORKDAY |
calculates a work day (non weekend or holiday) from a start date and offset |
| WORKDAY_q |
calculates a work day (non weekend or holiday) from a start date and offset |
|
|
Function Reference - Version Information
|
|
|
Gettysburg Address
|<< Back |