Ladies and Gentlemen,
I am pleased to offer, free of charge, the following string functions
Transact-SQL:
AT(): Returns the beginning numeric position of the nth occurrence of a
character expression within another character expression, counting from the
leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a
character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within
another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within
another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or
characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or
characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a
character in a second character expression with the corresponding character
in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second
character expression, and then replaces each occurrence with a third
character expression. Unlike a built-in function Replace, STRTRAN has three
additional parameters.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
GETALLWORDS(): Inserts the words from a string into the table.
PROPER(): Returns from a character expression a string capitalized as
appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right
search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified
numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman
numeral expression (from I to MMMCMXCIX).
AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP.
Plus, there are CHM files in English, French, Spanish, German and Russian.
Plus, there are versions for SYBASE ASA, DB2, Oracle, MS SQL SERVER 2005
SQLCLR.
More than 8000 people have already downloaded my functions. I hope you will
find them useful as well.
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
With the best regards.