Jamie,
Where do I type the formula and will I get a separate column that will
isolate the string I'm looking for, or will I merely be able to query on that
string? This is all new to me so I need some more specific instructions.
Thank you

"Jamie Collins" wrote:


Excel GuRu wrote:
I'm querying
an
oracle database. I'd like to limit the amount of records that
come
accross
so the file is easier to manage. We have 9 digit sales part
numbers.
Each
digit has significance. I'd like to isolate three characters,
4-6, and
bring
only those records where these digits are equal to 123.

try
putting the following criteria in as follows:

Criteria: LEFT(PartNo,3)
Value: 123


thanks for the quick response , but I couldn't get this to work the
way
you described.

Try Oracle syntax:

SUBSTR(PartNo,4,3)

Jamie.

--