Every column in a table has a name and a data type. The data type tells DB2 how much physical storage to set aside for the column and the form in which the data are stored. DB2 uses IBM SQL data types ...

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

Hmm, hard to say without knowing exactly how the data is going to go from one database to another. I do think though that the T-SQL function ISNUMERIC () could be helpful.