sql server string types code example

Example: sql What type is that value?

SELECT TYPEOF(value);