anthony.green (7/26/2012)
Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.Gone with John's responce as its the simpler to impliment, just changed the -1 to a -2 to remove the comma and the space.
Cheers again gents.
Be sure to handle nulls appropriately (something STUFF does for you). If you don't any one null entry in the table will NULL out the entire list.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?