sql set data type to exact amount code example

Example: sql What type is that value?

SELECT TYPEOF(value);