LIKE command with % when character at middle
select stdName,stdAddress from student where stdAddress like '%a%'
there is some good c ,java, sql and vb6 programs,Windows tricks, sms shorthand etc
select stdName,stdAddress from student where stdAddress like '%a%'