simple question

I have a data base that contains a row or various letters. I want to check and see it a letter is in the row. If it is I want the row to be returned as a result. Right now the code I have is only returning the result if that is the only letter in the column. i.e. if the column is C,V,B,J and I'm searching for C then this is not returned. But if the column is just C and I'm searching for C then it is returned. How do I amend my code to see if the column contains the letter I'm looking for. It doesn't have to be the only letter in the column. Here is what I have...

<cfargument name = "amenities" type = "string" required= "true">
<cfset qualifiedAmenities = ListQualify(amenities,"'")>
SELECT * FROM SingleFamily
WHERE AMEN IN (#PreserveSingleQuotes(qualifiedAmenities)#)

Thank-you for your help

You can try the following query:
Select * from <table> where AMEN like '%<cfoutput>#qualifiedAmenities#</cfoutput>%'