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
My fellow monks
Can't tell (I'm NSA/FBI/HS/...)
Others (explain your deviation)
Results (56 votes). Check out past polls.