Hello,
For some reason my email generation rule is removing the apostrophe out of the users firstname and I do not have any replace function in my email generation rule. I may be overlooking something below is my current rule.
case
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'@domain.com') = users.email) then concat(users.firstname,".",users.lastname,'@domain.com')
when (select count(*) from users where concat(users.firstname,'.',substring(users.middlename,1,1),'.',users.lastname,'@domain.com') = users.email) then concat(users.firstname,'.',substring(users.middlename,1,1),'.',users.lastname,'@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'1','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'1','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'2','@domain.com') = users.email) then concat(users.firstname,users.lastname,'2','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'3','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'3','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'4','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'4','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'5','@domain.com') = users.email) then concat(users.firstname,users.lastname,'5','@domain.com')
ELSE concat(users.firstname,'.',users.lastname,'6','@domain.com')
end
[This post has been edited by a Moderator to remove sensitive information.]
