Código SQL:
Ver originalCREATE TABLE #temp
(
num VARCHAR(20)
)
INSERT INTO #temp VALUES ('1')
INSERT INTO #temp VALUES ('2')
INSERT INTO #temp VALUES ('3')
INSERT INTO #temp VALUES ('4')
INSERT INTO #temp VALUES ('10')
INSERT INTO #temp VALUES ('16')
SELECT MAX(CONVERT(INT,num)) AS numero FROM #temp
saludos!