Hi..

try the following query..

Select * from tablename where name like '%s' or name like '%r'