I have a field which contains values like  - Sample, [1234F] - Face Sample and further more. I want to get the rows using SOQL query with this field in where condition, when using below query there are no rows returned
Select Name, Id, Sample__c from Custom_Object__c where Sample__c = ' - Sample'
Even checked in Developer Console under Query tab, it did not returned any rows. But with below query I got results (which included few unwanted rows too because of Like condition)
Select Name, Id, Sample__c from Custom_Object__c where Sample__c LIKE '%1234%'
But I want only rows which were matching with entire value rather than LIKE. Please suggest me how to achieve it.
Note sometimes values can be " & [1234F] - Sample case"