If you want the MIN and MAX based on their numeric values you will need to convert to it:
SELECT '#TmpAct' AS TableName,'ACCOUNT_ID' AS ColumnName
, COUNT(DISTINCT CAST(ACCOUNT_ID AS VARCHAR(MAX))) AS NumDistinctValues
, MIN(CASE WHEN ISNUMERIC(CAST(ACCOUNT_ID AS VARCHAR(MAX))) = 1 THEN
CAST(CAST(ACCOUNT_ID AS VARCHAR(MAX)) AS NUMERIC)
ELSE NULL -- or 0 as you wish
END
) AS MinValue
, MAX(CASE WHEN ISNUMERIC(CAST(ACCOUNT_ID AS VARCHAR(MAX))) = 1 THEN
CAST(CAST(ACCOUNT_ID AS VARCHAR(MAX)) AS NUMERIC)
ELSE NULL -- or 0 as you wish
END
) AS MaxValue
FROM #TmpAct;
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]