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-01-16 : 22:24:39
|
Michael writes "I am developing a web-based application. Maybe I have not normalized my structure correctly, but I have three tables: tblSections, tblPageAreas, tblPolicies. In each of these tables, I need to specify the geographies they apply to. From the web interface, I would like to be able to add a new record to any of these tables, passing a comma delimited string of values (1, 2, 3) to the country field, indicating the counties this record applies to. This is simple enough, but then how do I query to pull the records back out if, say I am looking for country 2 only.
the table could look like this:
id..... desc........ country
------- ------------ ------------
1...... policy-1.... 1, 2, 3
2...... policy-2.... 1, 2
3...... policy-3.... 1
4...... policy-4.... 2, 3
Thanks for any help!
Michael" |
|
|
|
|
|
|
|
field with multiple values