substring(email from 0 for position ('@' in email)) substring(email from position ('@' in email)+1 for char_length(email)) +1 to ignore the @ logo LEFT(email, POSITION('@' IN email)-1) -1 to ignore the @ logo
substring(email from 0 for position ('@' in email)) substring(email from position ('@' in email)+1 for char_length(email)) +1 to ignore the @ logo LEFT(email, POSITION('@' IN email)-1) -1 to ignore the @ logo