How to select max number from substring result of SQL query

Syntax:: select max(convert(int,substring('FeildName',startpos,endpos)))) from tablename

E.g.: select max(convert(int,substring(cardid,3,len(cardid)))) from products