Expressions: Case When Substring CharIndex I am using the following sql query to remove some unwanted strings. select case when sSource like '%<%%' then SUBSTRING(sSource, 1,charindex('<' ,SSource)-1) else sSource end from [xx].[xx].NmsTrackingUrlIt will cleanse the record and remove the string (<% } %>)Now I am trying to do the same on a worflow but I am having trouble converting the expression.Case(When(@source LIKE '<%', Substring(@source,1 , Charindex('<', @source)-1), Else(@source)))The error is the following.. anyone can give me a hand?I can see that the case expression is being interpreted wrongly by Neolane and it should be 'Case When' not 'Case(When' so I used the following expression instead, it also performs a CASE but the error is differen