Remove one work with create as a column

1

Hello, I have a column when it has data such as this:
"CFTSS Treatment Plan Review - 10/01/2020 12:00am"
the date /time would change not the word 'Review' I would like to extract
the world review and assign to an output column.

2

So what would you like the final data look like

3

I want the column "CFTSS Treatment Plan Review - 10/01/2020 12:00am" but also
one that has 'Review'.

4

Not sure I understand what you are asking. Let's see if someone else does

5

In the data selected we select a column called 'Generic Description'
for those rows that have the string 'CFTSS Treatment Plan Review - 10/01/2020 12:00am' ( the date would change so we are looking for the word 'Review') we wanted to create a column with the word 'Review'

6

CASE WHEN [Generic Description] Like '% Review %' THEN 'Review' ELSE '' END

7

thanks, that is nice. How could you get a column name also?

8

CASE WHEN [Generic Description] Like '% Review %' THEN 'Review' ELSE '' END
AS
column_name_you_want

example
CASE WHEN [Generic Description] Like '% Review %' THEN 'Review' ELSE '' END
AS
WORD