Here are some useful User-Defined String Functions for SQL Server 2005.
| AT()Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. OCCURS()Returns the number of times a character expression occurs within another character expression. 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. GETWORDCOUNT()Counts the words in a string. GETWORDNUM()Returns a specified word from a string. PROPER()Returns from a character expression a string capitalized as appropriate for proper names. Plus, there are CHM files in English, French, Spanish and German. Plus, there are versions for SQL SERVER, SYBASE ASA, DB2, Oracle. For more information about string UDFs please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,29527 |
Tuesday, March 28, 2006 4:58 AM