Hello,
I've got a "Salesforce Database Error" message when I am trying to do a multiple LIKE statement.
Is there an alternative way or it is Salesforce limitation?
Thank you!
Min
Multiple LIKE operators are indeed supported within Toad Data Point, so the Database Error from SalesForce you're getting is very likely not from the SOQL syntax involving LIKE.
Encouraging you to read the SalesForce Query limitations found in Toad's Help file. There are some restrictions imposed by SalesForce, and some by TDP's Query Builder... For example, TDP only allows child to parent relationships in the visual Query Builder, bind variables are not supported, Salesforce itself doesn't support more than one child table reference, or more than two sub-queries, etc.