Took some help from a friend but the answer turned out to be simple

isnull(cast([OriginatingLeadId] as VARCHAR(36)),'NA')

when checking for NULL in a uniqueidentifier field you have to cast it as VARCHAR...

As noted above if you have MS Access use that, very easy to do what you want with MS Access.

However you can do this

write a delete statement to remove...