I was able to figure it out myself.

select distinct substring(convert(varchar(6), replicate('0',6-datalength(ltrim(str (NAME_MASTER.id_num,6))))

+ ltrim(str(NAME_MASTER.id_num,6))),1,6)

+ ' '

+ 'Y'

+...

My format is not staying when I paste it in. Is there a different tool I can use?

Ok, thanks. I will add the data definitions and the execution plan.

Thank you for the replies. I was about to restore the backups and my server is back up.