I have a field in a table called email_staff. It is a varchar 50 null. Some are entered as jsmith and others are entered as jsmith@companyname.org
I need a report of only the ones who have the @companyname.org I tried this sort of code but it does not work:
`Select Last_name, First_name, email_staff from staff_view
Where email_staff like '@'
