One of the most common reasons why people use dynamic SQL, is to handle the case when the user can specify one, two or any amount of values to be searched upon.