Login
Register
Contact Us
Search
Menu
Home
Products
XLeratorDB
function packages
for SQL Server
financial
view documentation
pricing
statistics
view documentation
pricing
math
view documentation
pricing
engineering
view documentation
pricing
strings
view documentation
pricing
financial-options
view documentation
pricing
windowing
view documentation
pricing
XLeratorDB
Compilation packages
for SQL Server
Suite
incl:
financial
,
statistics
,
math
,
engineering
&
strings
pricing
Suite (Developer)
requires SQL Server Developer Edition
pricing
Suite (Subscription)
One-year non-recurring license
pricing
SuitePLUS
incl: all Suite packages PLUS
financial-options
pricing
SuitePLUS (Developer)
requires SQL Server Developer Edition, also incl:
financial-options
pricing
SuitePLUS (Subscription)
One-year non-recurring license, also incl:
financial-options
pricing
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
view documentation
pricing
SQL Server not required
View All Product Pricing ...
Download Free 15 Day Trial ...
Documentation
Purchase
XLeratorDB
function packages for
SQL Server (2008 & later)
financial
statistics
math
engineering
strings
financial-options
windowing
XLeratorDB
Compilation packages for
SQL Server (2008 & later)
Suite
Suite (Developer)
Suite (Subscription)
SuitePLUS
SuitePLUS (Developer)
SuitePLUS (Subscription)
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
Legacy XLeratorDB Packages for
SQL Server 2005
financial
for SQL Server 2005 only
statistics
for SQL Server 2005 only
math
for SQL Server 2005 only
Suite
for SQL Server 2005 only
Suite (Developer)
for SQL Server 2005 only
SuitePLUS
for SQL Server 2005 only
SuitePLUS (Developer)
for SQL Server 2005 only
Download Trial
Case Studies
Blog
Support
XLeratorDB/strings Online Documentation
Home
Search
Recent Changes
Show All Pages
Strings Functions Index ...
Formatting
CLEAN - remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text
CONCAT - concatenate the contents of 2 columns
CRLF - insert a carriage return (Char(13)) line feed (Char(10)) into a string
DEC2FRAC - convert a number into its fractional representation
DOLLAR - convert a number to text using currency format, with the decimals rounded to the specified place
FIXED - format a number in decimal format using a period and commas, round the number to the specified number of decimals, and return the result as text
FORMATDATE - convert a datetime value to text and specify the display formatting by using special format strings
FORMATNUM - convert a numeric value to text and specify the display formatting by using special format strings
FRAC2DEC - convert a fraction, as text, to a numeric value
INDENT - place characters at the beginning of a string of text
JOINSTR - concatenate the text from multiple rows in a table
JOINSTR_q - concatenate the text from multiple rows in a table
PADLEFT - place characters at the beginning of a string of text, when the length of the text is less than the specified width
PADRIGHT - place characters at the end of a string of text, when the length of the text is less than the specified width
PARSE - find a word in a string based on its word position in the string
PCT2FRAC - convert a percentage into its fractional representation
PROPER - capitalize the first letter in each word of a string of text
QUOTED - add quotation marks (CHAR(34)) to the beginning and end of a string of text
QUOTES - add quotation marks (CHAR(39)) to the beginning and end of a string of text
SPLIT - single column table containing the substrings between the specified delimiter passed to the function
STRIP - remove punctuation from the beginning and end of a string
SUBSTITUTE - substitute new_text for old_text in a text string
TEXT - convert a numeric value to text and specify the display formatting by using special format strings
TRIM - remove trailing and leading spaces from a string of text
VALUE - convert a text string that represents a number to a number
Inspection
CONTAINSSTR - determine if a string contains a particular value
COUNTSTRING - count the number of times a particular text occurs in another text
ENDSWITH - determine if a string ends with a particular value
EXACT - compare two text strings
FIND - locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string
INSTR - integer specifying the position of the first occurrence of one string within another
INSTRREV - integer specifying the position of an occurrence of one string within another, from the end of string
ISALPHA - determine if a value contains only alphabetic characters [a-z][A-Z]
ISNUMERIC - determine if a value is numeric
NUMWORDS - number of words in a string
STARTSWITH - determine if a string starts with a particular value
Calendar
NETWORKDAYS - number of whole working days between a start date and an end date
NETWORKDAYS_q - number of whole working days between a start date and an end date
WORKDAY - the date that is the indicated number of working days before or after a date (the starting date)
WORKDAY_q - the date that is the indicated number of working days before or after a date (the starting date)
Logic
IIFSTR - one of two parts, depending on the evaluation of an expression
Misc Functions and Test Data
XLDB_STRINGS_VERSION - get the XLeratorDB / strings version information
Gettysburg Address
ALL FUNCTIONS (alpahbetical)
CLEAN - remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text
CONCAT - concatenate the contents of 2 columns
CONTAINSSTR - determine if a string contains a particular value
COUNTSTRING - count the number of times a particular text occurs in another text
CRLF - insert a carriage return (Char(13)) line feed (Char(10)) into a string
DEC2FRAC - convert a number into its fractional representation
DOLLAR - convert a number to text using currency format, with the decimals rounded to the specified place
ENDSWITH - determine if a string ends with a particular value
EXACT - compare two text strings
FIND - locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string
FIXED - format a number in decimal format using a period and commas, round the number to the specified number of decimals, and return the result as text
FORMATDATE - convert a datetime value to text and specify the display formatting by using special format strings
FORMATNUM - convert a numeric value to text and specify the display formatting by using special format strings
FRAC2DEC - convert a fraction, as text, to a numeric value
IIFSTR - one of two parts, depending on the evaluation of an expression
INDENT - place characters at the beginning of a string of text
INSTR - integer specifying the position of the first occurrence of one string within another
INSTRREV - integer specifying the position of an occurrence of one string within another, from the end of string
ISALPHA - determine if a value contains only alphabetic characters [a-z][A-Z]
ISNUMERIC - determine if a value is numeric
JOINSTR - concatenate the text from multiple rows in a table
JOINSTR_q - concatenate the text from multiple rows in a table
NETWORKDAYS - number of whole working days between a start date and an end date
NETWORKDAYS_q - number of whole working days between a start date and an end date
NUMWORDS - number of words in a string
PADLEFT - place characters at the beginning of a string of text, when the length of the text is less than the specified width
PADRIGHT - place characters at the end of a string of text, when the length of the text is less than the specified width
PARSE - find a word in a string based on its word position in the string
PCT2FRAC - convert a percentage into its fractional representation
PROPER - capitalize the first letter in each word of a string of text
QUOTED - add quotation marks (CHAR(34)) to the beginning and end of a string of text
QUOTES - add quotation marks (CHAR(39)) to the beginning and end of a string of text
SPLIT - single column table containing the substrings between the specified delimiter passed to the function
STARTSWITH - determine if a string starts with a particular value
STRIP - remove punctuation from the beginning and end of a string
SUBSTITUTE - substitute new_text for old_text in a text string
TEXT - convert a numeric value to text and specify the display formatting by using special format strings
TRIM - remove trailing and leading spaces from a string of text
VALUE - convert a text string that represents a number to a number
WORKDAY - the date that is the indicated number of working days before or after a date (the starting date)
WORKDAY_q - the date that is the indicated number of working days before or after a date (the starting date)
XLDB_STRINGS_VERSION - get the XLeratorDB / strings version information
CoVariance
View Topic History