by using PATINDEX EX: select PATINDEX('%[A-Z]','SURABITH')