I have a query that runs and produces me exactly what I want. It just has more information in the result than what I need. It has text in the result that I do not want. For example I get the following:
Customer email changed from email@example.com; firstname.lastname@example.org to email@example.com; firstname.lastname@example.org.
This is always the same but I would like to only display everything after "to"
SELECT TOP (100) PERCENT CallDateTime, AccountNumber, CallID, Issue, CallType
WHERE (CallType = N'Notification') AND (Resolved = 0)
ORDER BY CallDateTime DESC