Desktop POS: Setting blank emails to @Noemail address Instructions to set blank emails to @noemail address update customer set emailaddress = '001.' + convert(nvarchar,id) + '@noemail.com' where emailaddress = ''