i have a column that is a Text column with the following info:
Note: Outgoing Call
Phone Call: Johnson, Ed
Number Called: (604) 601-8000
Phone Description: Main
Subject: Arrange trip
Result: Discussed opportunities
I want to know if it is possible to get the Subject and Result in two separate columns?
is this possible using a select case statement?
i want the result to look like this:
Subject | Result | Note
i have this which works however if the text is longer than what i have put in below - how do i then see all text
,"Result"=SUBSTRING(TextCol,135,33) FROM AMGR_Notes where type = 2
Could someone please point me in the right direction and i will right the query