ntext addition question

[bhp]

Hi I have 2 columns from a table as follows:

ID(int) Note(ntext)

10 dsdadasdasdsdads ewrewr
10 asdsdsdasdasdasd
10 sdsa
11 cvxvcvxvcxvcvx cxvcxvxv
11 frfwefwfwr wrfrw rw wr
4 opeiqwei
4 wqwdqdedd
4 eeweqeq

All I need to do is return the id and all of the text from the Note field from that ID, e.g.
10 dsdadasdasdsdads ewrewr asdsdsdasdasdasd sdsa
Does anyone know if this is possible? thanks

 

[mrdenny]

Yeah, a normal select statement will do that.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bhp]

Hi
Thanks for the response but not sure how you could add the notes field together for each ID with a select ?
i.e. select ID, Note would only return all rows I do not have any criteria just that for each ID all the note daat for that ID must be displayed. thanks!!!