dcsimg
Results 1 to 1 of 1

Thread: Free User-Defined string Functions Transact-SQL

  1. #1
    Join Date
    Apr 2005
    Location
    Montreal
    Posts
    8

    Free User-Defined string Functions Transact-SQL

    http://www.universalthread.com/wconn...~2,54,33,27115

    Description
    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

    For more information about string UDFs Transact-SQL please visit the
    http://www.universalthread.com/wconn...~2,54,33,27115
    Attached Files Attached Files

Posting Permissions

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