SQQL Query (Salesforce Input)

[TommyLau]

Hi, any solutions for this issue? Thanks

[BrandonB]

It looks like SalesForce doesn't like the plus operators in your WHERE clause. Are you trying to look for names that have a carriage return in them? 

[TommyLau]

Thanks for the reply, but I couldn't find any other operators that can replace "+"

[BrandonB]

Aren't New Line and Carriage Return represented by \n and \r respectively? https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sel... 

It has been a bit since I have written SOQL, but wouldn't it be something like: WHERE name LIKE '%\r%'