I am trying to run SOQL statement in salesforce.schema tool of FORCE.COM the following query:
Select c.LastName, c.FirstName From Contact c WHERE (FirstName+' '+LastName) In ('Good Name','Bad Name')
It produces an error.
Can I do this kind of things with SOQL ? If yes, then how I can concatenate fields in the query ?