Ladies and Gentlemen,

I am pleased to offer the following string functions SQL Procedural
Language DB2:

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 SQL PL function LOCATE, 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 MS SQL SERVER, SYBASE ASA, Oracle.

More than 7000 people have already downloaded my functions. I hope you
will find them useful as well.

For more information about string UDFs SQL Procedural Language DB2
please
visit the
http://www.universalthread.com/wconn...~2,54,33,29032

Please, download the file
http://www.universalthread.com/wconn...reme~2,2,29032

With the best regards.