views:

2055

answers:

3

Can anyone give me a complete list of string manipulation function in Microsoft SQL Server (2000 or 2005)?

(I don't need a lecture about doing all my string processing in the presentation layer. And, I don't need a list of MySQL string functions.)

Thanks!

+4  A: 

String Functions (Transact-SQL)

Kevin Fairchild
I missed it by that much!
Mitchel Sellers
Thanks guys. I had seen that page but totally missed the box in the upper right part of the page with a link to the 2005 version of the page.
BoltBait
A: 

MSDN and Google are your friends

here is the 2008 version, drill down to your specific flavor.

Mitchel Sellers
A: 

Looking over the msdn list I noticed that HashBytes() is missing. I suppose it falls under a different category, but it's definitely an operation performed on a string, and useful to know about.

Joel Coehoorn