<div>
Is the Orig Information always in that format?<br />
If so you can do something like<br />

<pre><code class="code-1 nolinks" id="code-20-41826329-1"><span>select * from table1 where [part number] &lt;&gt; mid([Orig Information],7,instr(7,[Orig Information],&quot;,&quot;)-7)</span>
</code></pre>
</div>


<div>
No unfortunately it isn't. &nbsp;It is a raw data field and can be in any format, I just want to be able to search within it for the match
</div>


<div>
@I just want to be able to search within it for the match<br />
<br />
Are there any sure delimiters? If not you should create some code to check into any string to strip out the value to match<br />
<br />
For example this query will select every record where part number is contained into Orig Information<br />

<pre><code class="code-1 nolinks" id="code-20-41826431-1"><span>select * from table1 where [Orig Information] LIKE &quot;*&quot;+[Part Number]+&quot;*&quot;</span>
</code></pre>
but if let's say every part number into the Orig Information is in format [space]Part No.[comma] (that is &nbsp; &quot;&nbsp;04567,&quot;) then you could use a query like
<pre><code class="code-1 nolinks" id="code-20-41826431-2"><span>select * from table1 where [Orig Information] not LIKE &quot;* &quot;+[Part Number]+&quot;,*&quot;</span>
</code></pre>
</div>


<div>
The ampersand (&amp;) is the standard Access concatenation character. &nbsp;The plus (+) can be used but it handles nulls differently so unless you need the special treatment of nulls, it is best to stick with standard.
</div>


<div>
The only solution or help suitable for FoxPro environment is in the post <a href="https:#a41826808" rel="ugc">https:#a41826808</a>. It explains how to define filters on the data in question to display data which follow given filter condition.<br />
<br />
Other answers did not reflect FoxPro environment so they cannot work.<br />
<br />
appelonia21, if you have additional questions to this subject ask then, if not then please close the question and mark the solution.
</div>


<div>
Unfortunately, just one correct solution suitable for FoxPro was provided. Other solutions do not work correctly in FoxPro or they suppose FoxPro knows VBA etc. Assisted points were assigned for the good Access solution.
</div>


<div>
<div class="content wysiwyg-content">
Here is my issue: &nbsp;I have a dbf table with following fields:<br />
Part Number &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Orig Information<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Seat, 123, Viton<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Seat, 04567, Viton<br />
<br />
I am trying to flag a field when the Part Number (123) is identified in the original field so that I can easily find items that need to be corrected. &nbsp;The 456 is incorrectly entered into the Part Number field, it should be 04567 but I need to identify the ones that we need to look at.
</div>
</div>


Here is my issue:  I have a dbf table with following fields:
Part Number               Orig Information
123                                Seat, 123, Viton
456                                Seat, 04567, Viton

I am trying to flag a field when the Part Number (123) is identified in the original field so that I can easily find items that need to be corrected.  The 456 is incorrectly entered into the Part Number field, it should be 04567 but I need to identify the ones that we need to look at.

Foxpro - Searching for numbers in separate column

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.