<div>
Thanks again Bill<br />
regards Jack
</div>


<div>
<div class="content wysiwyg-content">
I have 2 keys in Pervasive database<br />
first keyfield could contain like following sample<br />
'ABRAHAM LINCOLN'<br />
second keyfield &nbsp;could contain like following<br />
CITY OF ABRAHAM <br />
ABRAHAM &nbsp;STREET<br />
NEXT DOOR IS ABRAHAM <br />
etc<br />
&nbsp; &nbsp; &nbsp;<br />
what is syntax if I need to search on word ABRAHAM from first field into the second keyfield <br />

</div>
</div>


I have 2 keys in Pervasive database
first keyfield could contain like following sample
'ABRAHAM LINCOLN'
second keyfield  could contain like following
CITY OF ABRAHAM 
ABRAHAM  STREET
NEXT DOOR IS ABRAHAM 
etc
     
what is syntax if I need to search on word ABRAHAM from first field into the second keyfield 


SQL ON PERVASIVE SERVER  SEARCHING FOR TEXT IN 2 FIELDS BASED ON COMPARED

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.