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
Fruit and Vegetables
Me, that's why I'm so cool
Logic (separated into Horror and Brilliance)
Results (269 votes). Check out past polls.