SQL语句求一列中的最大数（该列为varchar类型）

[飞木银钐]

求大神帮忙：
SQL语句求一列中的最大数（该列为varchar类型）



如图，求图列的最大整数（排除含字母的数据）（结果应为2015092409）

请问SQL语句怎么写？？？

[唐诗三百首]

try this,

select max([列名])
  from [表名]
  where isnumeric([列名])=1

[飞木银钐]

引用 1 楼 ap0405140 的回复:

try this,

select max([列名])
  from [表名]
  where isnumeric([列名])=1

感谢，感谢，完美解决问题

[载河之舟]

create table tb
(Sid int,SSno varchar(10))
 go
insert into tb
 select 1,'2015092401' union all
 select 2,'2015092403' union all
 select 3,'2015092405' union all
 select 4,'2015092407' union all
 select 5,'2015092409' union all
 select 6,'793232' union all
 select 7,'12324222' union all
 select 8,'A02782' union all
 select 9,'n2930'
 
 
 select MAX(convert(int,ssno)) from tb where isnumeric(ssno)=1

[道素]

 DECLARE @t TABLE (v VARCHAR(100))
 INSERT INTO @t
 SELECT '100' UNION
 SELECT '2'　UNION
 SELECT 'A200' 
 
 SELECT MAX(convert(BIGINT,t.v)) FROM @t AS t WHERE ISNUMERIC(t.v)=1