select email,ltrim(email,substr(email,1,instr(email,'@'))) from emp15; select email, substr(email,1,instr(email,'@')) from emp15;