Assuming you're telling us that each of the values in your list is in a separate row. The answer is: SELECT Column, list? FROM Table WHERE Column IN ('a', 'aa', 'aaa') If this is incorrect then "KenJ" has the right answer.
An alternative to @dvroman's suggestion, if you *know* that your data only has alphabetical characters in, is to do: SELECT Column FROM Table WHERE Column LIKE '%a%' AND Column NOT LIKE '%[b-z]%' Here, we're making more interesting use of wildcards. Have a look at the MSDN documentation for [`LIKE`] for even more on wildcards. Of course, there are all sorts of potential issues with this one. Collations, case sensitivity, what if there is non-alpha data... :