Does anyone have a function that will tell me if a Data.DataColumn is a Number?

I need to build an SQL String based off this information.

a simple example would be

if the column is a string the sql statement must look like this

select * from customers where customer_name = 'X'

if the column is a numbe it must be like this

select * from customers where customer_id = 1