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 ...

Returns the substring of a string s which starts at the specified byte index offset.Byte counting starts from 1. If offset is 0, an empty string is returned. If offset is negative, the substring ...

Result set from the “split_string” table-valued function 3. Use XQuery to Split the String Value and Transform a Delimited String into XML. Turning a delimited string into XML using XQuery is a ...