I need some help comparing a value to a list of values in a database. Database is sql server coldfusion is mx.
I have many hundreds of thousands of records is this database and one column is a catid field it can be a single number or it can be a list of numbers, i.e., 3,4,51. The problem I am having is that I am trying to pull all the records that are in a category. so i want all the records that have a catid of 5 or that have 5 in their list of records i.e., 4,5,51 and this is where I am having a problem my query will pick out all the 5's but ignore the ones that have multiple entries i.e.,4,5,23 that record would not get added into my query. Any help would be grately appreciated. -- Patrick Forsythe Tech Support Smallville Communications http://www.toto.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54