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-04-03 : 09:57:55
|
writes "Hi Team,
I want to select all rows from a db table that contains any of the folowing values. The values are in a string, separated with commas like this:
24, 37, 58
I have 3 rows in a db table (varchar) with values like this:
Row 1: 24, 57, 43, 67
Row 2: 22, 35, 37, 98
Row 3: 44, 55, 66
My search should select rows number 1 and 2 because row 1 contains the number 24 from the search list and row 2 contains the number 37.
If you can reccommend inserting my values in the database in a differen form, that will be easier to search - great!
As you can probably see I am a newbie in database development, so please go easy on me if you can.
My db is running of SQL Server 2000 Standard Edition.
Thank you,
Vesselin." |
|
|
|
|
|
|
|
design