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
1. Keep it simple
2. Just remember to pull out 3 in the morning
3. A good puzzle will wake me up
Many. I like to torture myself
0. Socks just get in the way
Results (330 votes). Check out past polls.