sql query / procedure

Question

Hi Expert

 

In my data one column is like this way

id-varchar(10)

a4563457

g5678456

d3456278

bjhh7898

678gjkl8

.....as like in this type of data i want only  1st character in a-z/A-Z, other 7  should be integers 

how could i validate this one, separate this kind of data . give me solution