Re: [OT] User-Defined string Functions MS SQL Server 2005 T-SQL VB.Net

[Vincent]

"Igor Nikiforov" <IgorNi...@discussions.microsoft.com> wrote in message
news:E95D6BC0-E823-4AB1...@microsoft.com...
> User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB.
> Net, C#.Net, C++. Net)
> Ladies and Gentlemen,
>
> I am pleased to offer, free of charge, the following string functions MS
SQL
> Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net):
>
> 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 MS SQL SERVER, SYBASE ASA, DB2, Oracle.
>
> More than 8000 people have already downloaded my functions. I hope you
will
> find them useful as well.
>
> For more information about string UDFs MS SQL Server 2005 Transact-SQL
> SQLCLR (VB. Net, C#.Net, C++. Net) please visit the
> http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,29527
>
> Please, download the file
> http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,29527
>
> With the best regards.
>

Puhutteko suomea? :-)