First off i want to point out that anytime you do something like it
should occur to you that this is probably not the best DB design and
could lead to more issues down the road...if this is indeed on of the
rare cases where this design makes sense. Then one option is to do
this CHARINDEX(','+item+',',search_item,0) > 0
where search item would be something like ',11,'
You could also do a simular thing with LIKE.... ','+item+',' LIKE '%,11,%'
Adam H
On Fri, 25 Feb 2005 08:41:20 -0400, Protoculture <[EMAIL PROTECTED]> wrote:
> I have a list of items in a db field [items]...
>
> 1,11,14,12,13,17,15,18,19,16,4
>
> Now I want to test that my item is one of those numbers thats is in that
> field and select that row. See below. If I have one number (11), I want it to
> select that row, so it needs to search the string of numbers in the field
> [items], unless there is a way to use IN keyword in this case? any ideas?
>
> eq..
>
> select * from myTable
> where items = 11
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196503
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
