Geeks With Blogs
Chris Breisch   .NET Data Practices
Search this Blog!

Here are some useful User-Defined String Functions for SQL Server 2005.


Description 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,54,33,29527

Posted on Tuesday, March 28, 2006 4:58 AM Database Practices | Back to top

Comments on this post: Some Useful UDF's for MS SQL 2005

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Chris J. Breisch | Powered by: