Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Igor2004
More clever than you
78 Posts |
 Posted - 2005-05-09 : 23:45:18
|
| Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL GETWORDCOUNT() Counts the words in a stringGETWORDNUM() Returns a specified word from a stringAT() Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost characterRAT() Returns the numeric position of the last (rightmost) occurrence of a character string within another character stringOCCURS() Returns the number of times a character expression occurs within another character expressionPADL() Returns a string from an expression, padded with spaces or characters to a specified length on the left sidePADR() Returns a string from an expression, padded with spaces or characters to a specified length on the right sidePADC() Returns a string from an expression, padded with spaces or characters to a specified length on the both sidesPROPER() Returns from a character expression a string capitalized as appropriate for proper namesRCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the rightARABTOROMAN() 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 1137 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 the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the filehttp://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-09 : 23:53:30
|
| How about not cross-posting (again), since you're not actually posting the code in these forums?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48509 |
 |
|
|
|
|
|
|
|
User-Defined string Functions Transact-SQL