2008-03-27 17:50:09 UTC
Although I'm more comfortable with SQL type queries, my server is not
setup to use the OLEDB provider, so, I'm using the ixsso object
The Index Server property that I'm querying is Filename.
Embedded within all the Filenames is an Invoice Number and a Project
Number. The Filename has a pattern something like this:
Where P = Project Number, G = Invoice Group, D = Date, and I = Invoice
This query below works, and it returns all PDF documents in the Index
Server catalog for a given project number:
#Filename = 123456*.pdf
I tried adding a phrase for the invoice number, but this query didn't
#Filename = 123456*.pdf and #Filename = *23232323*
Thank you for your help.