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
Conway's Game of Life
Perl regular expressions
My Magic 8-Ball™
Results (183 votes). Check out past polls.