Simple Find - confused

[UntilTomorrow]

Hello,

I am trying to do a simple find in Find mode but it seems to have changed greatly in version 6.0 than any other versions. I am not doing any scripting or anything complicated, just a basic find.

I have a field where the records contain names similar to this "12345-P.fin". The only thing that may possibly change in certain records names' would be the character before the extension (ex. A.fin, D.fin, etc.) When I perform a find for "P" (without the quotes) it only give me files that contain a parens before the hyphen (ex. 12345(ost)-P.fin ) and none of the other "P" files.

To me it seems logical that if you ask for all records that have the letter "P" in them that you would see ALL of these records.

I have done this with success in past versions. Is there something new in version 6 that I just don't understand?

Thank you,

Steve

[Jim McKee]

Hi Steve ...

If your field is formatted exactly as you say it is:

*P should do the trick.

[Lee Smith]

Hi Jim,

Provided it is a text field and not a number field.

Lee

[UntilTomorrow]

Thanks Jim!

It worked but I am confused as to why I need to use * before the "P". I don't recall ever doing that in version 5 and below.

Thanks,

Steve