Hopefully what I posted works for you, unfortunately I just noticed that you had posted in a SQL Server 7/2000 forum and the code I provided will work in SQL Server 2005 and later, not in SQL Server 2000.