• Thanks for you response, this will work for my initial question. Unfortunatly i have about 70 columns, is there a short way of doinf this without clobbering the sql codes with empty strings?

    i know that its can be done in excel but was wondering if there is a sql statement that does it inside sql server