Hi Team,
I have written the logic like below to generate the unique email address but when I am executing it I am getting "Operation not allowed as you are entering a value that resembles or contains SQL query" error on the second iteration. Please suggest
Requirement: Generate email as per below logic
1. first character of first name+lastname +@abc.com
2. if first name is of two words then: first character of first word of firstname +first character of second word of firstname+lastname+@abc.com
3. first character of first name + dot(.)+lastname+@abc.com
---------------------------------
CASE WHEN (LENGTH(users.FIRSTNAME) > 0 AND LENGTH(users.LASTNAME) > 0) THEN REPLACE(lower(concat(substring(users.FIRSTNAME,1,1) , users.LASTNAME ,'@abc.com')),' ','')END###
CASE WHEN (LENGTH(users.FIRSTNAME) > 0 AND LENGTH(users.LASTNAME) > 0) THEN REPLACE(lower(concat(SUBSTRING(users.FIRSTNAME,1,1),SUBSTRING(users.FIRSTNAME, INSTR(users.FIRSTNAME, ' ') + 1, 1),users.LASTNAME,'@abc.com')),' ','')END###
CASE WHEN (LENGTH(users.FIRSTNAME) > 0 AND LENGTH(users.LASTNAME) > 0) THEN lower(concat(substring(users.FIRSTNAME,1,1) , '.' , users.LASTNAME , '@abc.com'))END
----------------------
