Beautiful! Worked like a charm. Always the simple things that seem to be the hardest.

Thanks to everyone for all the help!

We don't really care if the value is numeric other than we are inserting the data into a column with a sql_variant datatype and want to store the data as...

Ok, I'll buy that. So given that fact, is there any other way to do this logically in one select statement and not have to break it out into...

Although it's probably a good idea, to learn a specific language (VB, C#, etc.), it's maybe even more important to learn the framework first. If you know procedural programming,...