<div>
It's not very clear what you really want. Do you want to filter records on some intrests (like every users that have interest soccer)? <br />

</div>


It's not very clear what you really want. Do you want to filter records on some intrests (like every users that have interest soccer)?


<div>
You want rows, not comma sepearted values<br />
<br />
CREATE TABLE myInterests99(UserId varchar(8), Interest varchar(25))<br />
GO<br />
<br />
INSERT INTO myInterests99(UserId,Inter<wbr />est)<br />
SELECT 'X002548','Skiing' UNION ALL<br />
SELECT 'X002548','Hockey' UNION ALL<br />
SELECT 'X002548','Tennis' UNION ALL<br />
SELECT 'X002548','Margarittas'<br />
<br />
<br />

</div>


You want rows, not comma sepearted values

CREATE TABLE myInterests99(UserId varchar(8), Interest varchar(25))
GO

INSERT INTO myInterests99(UserId,Interest)
SELECT 'X002548','Skiing' UNION ALL
SELECT 'X002548','Hockey' UNION ALL
SELECT 'X002548','Tennis' UNION ALL
SELECT 'X002548','Margarittas'




<div>
Dear aoreshkova..<br />
yes!<br />
Thats wat i m looking for..<br />
like select * who like soccer!<br />
:)<br />
<br />
DOes that means my select statement need to use LIKE '%soccer%'<br />
what does % means?<br />
<br />
X002548... i will try out ur method!<br />
:)
</div>


Dear aoreshkova..
yes!
Thats wat i m looking for..
like select * who like soccer!
:)

DOes that means my select statement need to use LIKE '%soccer%'
what does % means?

X002548... i will try out ur method!
:)

<div>
<div class="content wysiwyg-content">
Hi!<br />
I would like to knoe if anyone knoes if i have a coloum name called Interest where people can key in different things, how am i gona differentiate it?<br />
Like my interest is play games , soccer , basketball , singing...<br />
<br />
How am i gona seperate like soccer into an individual interest ?<br />
<br />
Can we like use comma?<br />
<br />
Also... if we use coma, when we do our select statement...<br />
how shall we go bout doin it?<br />
<br />
Please advice
</div>
</div>


Hi!
I would like to knoe if anyone knoes if i have a coloum name called Interest where people can key in different things, how am i gona differentiate it?
Like my interest is play games , soccer , basketball , singing...

How am i gona seperate like soccer into an individual interest ?

Can we like use comma?

Also... if we use coma, when we do our select statement...
how shall we go bout doin it?

Please advice

Question - Comma as seperator?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.