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.

--