<div>
<div class="content wysiwyg-content">
I have a key in Pervasive database<br />
this keyfield could contain like following samples <br />
CHICKEN FLORIDA PEPPER<br />
PEPPER BREAD FLORIDA<br />
FISH SAUCE FLORIDA<br />
FLORIDA BREAD<br />
<br />
what is syntax if I need to search on one word in the &nbsp;database like here<br />
I need all keys wich contains the search &nbsp;'FLORIDA' &nbsp; &nbsp; or &nbsp;'FLORI' &nbsp;in this keyfield<br />
<br />
<br />
<br />
<br />

</div>
</div>


I have a key in Pervasive database
this keyfield could contain like following samples 
CHICKEN FLORIDA PEPPER
PEPPER BREAD FLORIDA
FISH SAUCE FLORIDA
FLORIDA BREAD

what is syntax if I need to search on one word in the  database like here
I need all keys wich contains the search  'FLORIDA'     or  'FLORI'  in this keyfield






SQL ON PERVASIVE SERVER  SEARCHING FOR A WORD IN A FIELD

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

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.