I have the following values stored in a comma delimited list... for example
there is a url variable #fc# that i need to find in the database field containing this list (named teams_selected). I tried to write a query to do as described but it doesn't seem to be working.
<cfquery>select * from teams_schedule_new where '#fc#' in (teams_selected) order by id desc</cfquery>
Your help is appreciated.