+ Start a Discussion
Ikram Momin 16Ikram Momin 16 

expecting a right parentheses, found 's'

I am trying to fetch PublicGroups having '(single quote) in its name using query : select Id from Group where (Name = 'AMER SDR's Group') AND Group.Type='Regular'
but query gets failed on soap ui as well as developer console with error :
from Group where (Name = 'AMER SDR's Group') AND Group.Type='Regular'
^ERROR at Row:1:Column:45
expecting a right parentheses, found 's'

Escaping ' with ' not worked 
Best Answer chosen by Ikram Momin 16
RituSharmaRituSharma
You will need to replace below text:
Name = 'AMER SDR's Group'

With:
Name = 'AMER SDR\'s Group'