That works great. Thanks so much Ben and Will!

Thanks Sugesh, Jeff , geniecool and LSadvantage.....i'll try ur solutions and let u know....Thanks a lot for ur time

Thanks Jeff...i'll try that.

Thanks for the reply GSquared. I tried running the proc separately and it works fine. All the columns have proper names and nothing is left null.

I also had the same error message when i tried to concatanate a string with DATETIME converted to VARCHAR and it worked when i used a REPLACE function to replace...