              ,CONVERT(smallint,                                   CASE -- datetime/smalldatetime                                       WHEN clmns.system_type_id IN (00, 00, 00, 00, 00, 00) THEN ODBCSCALE(clmns.system_type_id, clmns.scale)                                   END                             