SQL Server Performance

User-Defined string Functions Transact-SQL

Discussion in 'Contribute Your SQL Server Scripts' started by bradmcgehee, May 10, 2005.

  1. bradmcgehee New Member

    Ladies and Gentlemen,

    I would like to offer you the following string functions Transact-SQL

    GETWORDCOUNT() Counts the words in a string
    GETWORDNUM() Returns a specified word from a string
    AT() Returns the beginning numeric position of the first 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
    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
    PROPER() Returns from a character expression a string capitalized as appropriate for proper names
    RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right
    ARABTOROMAN() Returns the character Roman number equivalent of a specified numeric expression
    ROMANTOARAB() Returns the number equivalent of a specified character Roman number expression ...

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

    For more information about string UDFs Transact-SQL please visit:
    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,
    Igor Nikiforov
    (Posted by Brad on behalf of Igor)


    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  2. surendrakalekar New Member

    Thanks Igor and Brad.
    This is really good for me as a beginner level DBA. But I will prefer to create my own instead of copy-paste.
    No doubt, this will be guideline/greater help for me.
    Thanks once again.
  3. Madhivanan Moderator

    This will be really useful for the beginners of SQL. Thanks Brad


    Madhivanan

    Failing to plan is Planning to fail
  4. FrankKalis Moderator

    My, oh my, he really posted that to each and every available community. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />

Share This Page