sql left email till @ symbol

i have a column called Email in my sql database so i need to left my column to get whats before the @ symbol

Answer

You can use split_part():

select split_part(email, '@', 1)