finding the charecter in the object

hi i have one query

suppose i have a data of two field

Name State

tom gujrat

billy rajasthan

jeny maharastra

now i want to check in "Name" field ,which are the record contains the letter 'y'

tht means after processing it shoud show output with word 'y' i.e.

Name State

billy rajasthan

jeny maharastra

thnks