Thank you very much!

Thank you for your reply. Unfortunately it still doesn't provide a solution to my particular problem. Its not the split that I am having difficulty with, but how to manipulate...

I resolved my particular issue as follows:

The primary key is composed of two columns, TRACKING_ID and MEASUREMENT_ID.

The TRACKING_ID identifies the process which gathered the data and MEASUREMENT_ID identifies the type...

That query returned both integers and real data types when run against the table.

Currently the table has 441 data columns and two identifying columns (that comprise the PK), the data type of which is defined as real. However, the data is composed of...

I cannot express how much I appreciate this article...  Being relatively new to the world of SQL Server 2000, I find this information very useful and valuable.  Keep up the...