>>>>You can't use [*g*.*] as a mask. You always will get a whole folder. try even in command prompt (old DOS) window:
>>>>DIR *g*.*
>>>>What you want? A file that have G somewhere in the name?
>>>
>>>Yes, but not in the extension part. Anyway, I think I can always call this program with extension, so this problem becomes mute. But I was a bit surprised to see this behavior.
>>
>>But this is the usual behavior, that mask [*G*.*] is equal to [*.*], you get ALL files, no matter where you use it - ADIR(), SYS(2000), DIR, no matter what language you will use. If you know what letter must be [G] you can use [???G*.*] if the [G] is third letter.
>
>That's not true for ADIR. It returns files containing G before the extension, e.g. in the file part.
HA! This is something new to me :-)
Thank you, I learned something today.
I always thing that that way works all file searching functions that allow wildcards in them.
Because I had a bad experience with that from my CLIPPER days I never tried this :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.