Now if I was using MySql I would use the Group_Concat function and I believe Sybase has something similiar called list, but unfortunately this function is not available to me. I am using Sybase 15.0.3 ASE
Thanks pdreyer for the reply, but I knew this, hence saying it was not available to me. What I'm after is what people do to get around this. Is there some sort of SQL to do this easily? My SQL isn't that great so just interest in some tips going forward with some I feel would be quite a common thing to do.