Sql query for finding length and ascii values

The Following Query is used for finding length of string in column

and aslo for finding ascii value for one char in spcified column.

select * from tblname len(substring(EmailID,charindex('@',EmailID),25))>23
select * from tblname where Ascii(SubString(EmailID,1, 1))>47 and Ascii(SubString(EmailID,1, 1))<58

This is useful for finding or deleting unnessary rows .