63 057
Assignments Done
99,1%
Successfully Done
In July 2018

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

Question #871
I need the SQL query for display the string after @ symbol
Ex: example@hh.com then I want only 'hh.com.'
Expert's answer
SELECT STUFF(ColumnID, 1, LEN(ColumnID)-CHARINDEX('@', ColumnID)+1,'');

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions