asp.net - Word specific search in asp using c# for auto-complete -

i have column in sql called "name", has these values:

abhay kumar rajesh saaw anjan raj gopal murti pravat saha 

now want sql code return words containing "r".

so in query, should return:

kumar, rajesh, raj, murti, pravat 

and not:

abhay, anjan, gopal, saha. 

the sql like operator should job. can compare against text pattern using following sql command form:

select ... name '%r%'; 

for example:

select name person name '%r%'; 

the % wildcard represents various count of various characters (similarly * in filenames). %r% means string contains letter r.