Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    7

    Unanswered: [OT] User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR .Net

    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/wconn...~2,54,33,29527

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

    With the best regards.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Igor! Long time no see! Its good to see that you've returned to re-enable the laugh track here at DBForums!

    It will be interesting to see the reception of this incarnation of your library in a new (CLR) environment! Someday I may download this incarnation myself.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •