470,644 Members | 1,202 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,644 developers. It's quick & easy.

User-Defined string Functions Transact-SQL

Ladies and Gentlemen,

I would like to offer you the following string functions Transact-SQL

GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a
character expression within
another character expression, counting from the leftmost character
RAT() Returns the numeric position of the last (rightmost) occurrence of a
character string within
another character string
OCCURS() Returns the number of times a character expression occurs within
another character expression
PADL() Returns a string from an expression, padded with spaces or
characters to a specified length on the left side
PADR() 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 sides
PROPER() Returns from a character expression a string capitalized as
appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but
the search of which is on the right
ARABTOROMAN() Returns the character Roman number equivalent of a specified
numeric expression
ROMANTOARAB() Returns the number equivalent of a specified character Roman
number expression ...

For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconn...~2,54,33,27115

Please, download the file
http://www.universalthread.com/wconn...reme~2,2,27115

With the best regards

Jul 23 '05 #1
0 1136

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by zlst | last post: by
3 posts views Thread by Jiho Han | last post: by
1 post views Thread by Robert Howells | last post: by
1 post views Thread by Demetri | last post: by
1 post views Thread by Carlettus | last post: by
3 posts views Thread by shapper | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.