User-Defined string Functions SQLCLR MS SQL 2005

Total article views: 331 | Views in the last 30 days: 16

 Rate this |   Join the discussion |  Briefcase

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. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). 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. 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/wconnect/wc.dll?LevelExtreme~2,54,33,29527 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,29527 With the best regards.

Total article views: 331 | Views in the last 30 days: 16