sql server - Searching Technique in SQL (Like,Contain) -

Comparing an area with DB using the keyword or any other technique like I I want to choose.

My query is:

  SELECT * to test name where '% xxxxxx_Ramakrishnan_zzzzz%';  

But in my field only include 'Ramakrishnan'

Some extra characters in my input string xxxxxx_ramakrishnan_zzzzz

I want to query SQL for this Am Can anyone help me?

Do you want you to do it on the other side? like this? Choose

  from selection * 'xxxxxx_ramakrishnan_zzzzz' like '%' + name + '%';