in reply to
(OT) Where is T-SQL's join function?
You would be better off asking on the microsoftsqlserver Yahoo group as your question is a MS TSQL question. I recommend using an user defined function to do what you want. An example of an SQL UDF.
Jason L. Froebe
Blog, Tech Blog
Priority 1, Priority 2, Priority 3
Priority 1, Priority 0, Priority -1
Urgent, important, favour
Data loss, bug, enhancement
Out of scope, out of budget, out of line
Family, friends, work
Impossible, inconceivable, implemented
Results (70 votes),