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-04-17 : 22:21:16
|
| http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115Description 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 side PADC() 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 rightFor more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 |
|
|
|
|
|
Free User-Defined string Functions Transact-SQL