Answer to Question #871 in Databases | SQL | Oracle | MS Access for Rajesh

Question

I need the SQL query for display the string after @ symbol
Ex: [e-mail] then I want only 'hh.com.'

Answer 1

SELECT STUFF(ColumnID, 1, LEN(ColumnID)-CHARINDEX('@', ColumnID)+1,'');