Thread: Parse String

See also http://br adsruminat ions.blogs pot.com/20 09/10/un-m aking-list -or-shredd ing-of-evi dence.html and try to apply it for your case.

I have a table with a column called members and in it the rows are like ID Members ---------- ----------- 1 1\2\3 2 2\3\4 3 2\3 4 1\5 I have a reference table where 1 = father, 2= mother, 3=sister, 4=brother, 5=grapnparents. Is there any way I can query the memebers table like this ID Members ---------- ------------------ 1 father,mother,sister 2 mother,sister, brother 3 mother,sister 4 father,grandparents. What I want to do is just replace...

use the inner join sentence, something like select a.id,b.members from table1 a inner join table2 b on a.members=b.id

mankish, What version of SQL Server are you using?  It'll make a difference in the code for the answer on this. --Jeff Moden ------------------------------------------------------------------------------- " RBAR " is pronounced "ree-bar" and is a "Modenism" for " R ow B y A gonizing R ow"

What you really need to do is change your exceedingly poor design. You should NEVER store mulitple peices if information in one field like that. You need a related table where you can store the data properly and then it is trivial to query.   "NOTHING is more important in a database than integrity." ESquared