title: Use LIKE in stored procedure with input parameter
body: <p>I have 2 input parameters and I want to search users where a part o the username is <code>@Username</code> and a part of the name is <code>@Name</code> that this users part of usernames is <code>@Username</code> and part of name is <code>@Name</code></p>
  
  <pre><code>SELECT *  
  FROM tbl_answer
  WHERE 
       an_del = 0 
       AND u_username = ISNULL(LIKE %@Username%, u_username) OR 
           u_name = ISNULL(LIKE @Name, u_name) 
  </code></pre>
  
  <p>How I can use <code>LIKE</code> in this stored procedure?</p>