Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 184.108.40.206 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
Checked for Relevance on 7-MAR-2016.
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Microsoft Windows 2000 Server SP 4
This document was previously published as Siebel SR 38-3064203411.
We need to query contact BC using eScript with search criteria as:
Last Name: O'Neal
First Name: Robert
Work Phone #: 3154323300
The character quote (') in last name is causing the problem in query.
I searched the support web & checked the most of the SRs (e.g 38-894480151 & FAQs on search expr)on this issue.
After referring to them, when I set the search expression as:
[Note that we already defined val1=Robert,val2=O'Neal,val3=3154323300]
The string 'strsrchExpr is formed as below:
Though this does not give any syntax error, this does not return the record in query.
Then we tried as:
This again doesn't give syntax error but string formed as below does not return the record either.
How can we set search expr to query string with quote(') in it, in eScript?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms