I need a query to search for a specific email address in a table called "dbo.Faults", in a column called "symptom2". The email address is only part of the "symptom2" column. The symptom2 column is set to (ntext,null)
How do I write this query?
AND (if it's easy enough to do) can I search for the email address and replace it with another?