How to get max value from like "A1...A10....A100"

Question

How to write Query for Get MAX value from This type of values 

 

"A1.....A10.....A100.....A1000" 

 

How to get the max value After "A"