select specify part of string using substring

PHOTO EMBED

Fri Apr 01 2022 06:54:39 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

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
content_copyCOPY