select a.name,case a.precision when 0  then   case a.is_ansi_padded  when 1 then  convert(nvarchar(15),b.name+ '('+convert(nvarchar(10),a.max_length)+')')  when 0 then  b.name end else   case a.scale  when 0 then b.name  else b.name+ '('+convert(nvarchar(10),a.precision)+','+convert(nvarchar(10),a.scale)+')' endend  as typelength from sys.columns a left join sys.types b on a.system_type_id=b.system_type_id and a.user_type_id=b.user_type_id where a.object_id =(select object_id from sys.objects where name ='Address')