Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-19 : 16:09:32
|
Jason writes "OK.
I have one table with catID (unique ID) and catDesc. I have another table with items listed. Each item has at least one, but may have a comma delimted list of catID's. These IDs are entered via an HTML form.
I would like to later be able to query the item table returning only items with catID x. The problem is if I use a LIKE statement and use a wildcard getting items with catID LIKE '%1' returns items with 1, 11, 111, etc.
What should I do?
I thought about modifying the whole system to add in new IDs as 3 digit numbers with leading zeros, but that is sort of a pain because of other existing areas.
Hopefully you can shed some light on a better way of designing this system so if I'm going to bust my ass its for a good reason. ;)
Thanks for any help.
-Jason" |
|
|
|
|
|
SQL Select on a field containing an ID array