Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

The fourth and last category of new T-SQL functions is String Functions, containing two new functions. Like other categories discussed here, this category provides functions that carry over from C# ...