CASE WHEN DATA_TYPE = 'varchar' OR DATA_TYPE = 'nvarchar' THEN '(' + ltrim(str(CHARACTER_MAXImUM_LENGTH)) + ')' WHEN DATA_TYPE = 'decimal' OR DATA_TYPE = 'numeric ...
WHEN descriptivegroup = '{"General Surface"}' AND make = 'Natural' THEN 'General Surface Natural Text' WHEN descriptivegroup = '{"General Surface"}' AND make ...