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

Thanks to Excel’s string functions, parsing is easy, as long as the source values are consistent. String functions, such as MID() need to know where the substring you’re extracting begins and ...