I am using SalesForce SOAP Enterprise WSDL API in my C# application.
What I came across is the need to use the
SELECT query which includes
I tried Developer Console>>Query Editor by executing the following query, but it's giving me
Unknown error parsing query
Following is my query that I want to execute :
`SELECT Id, Name, HomePhone, MobilePhone, OtherPhone, office_phone__c.replace("-",""), phone_fax__c FROM Contact`
I also tried in the following way, but that's also giving me the same error.
`SELECT Id, Name, HomePhone, MobilePhone, OtherPhone, REPLACE(office_phone__c,'-',''), phone_fax__c FROM Contact `
As the query implies, I want to replace
"-" in my
office_phone__c field with
Has anyone used such type of query before. I would be very grateful if anybody can lead me in the right direction.