Query question

[Santacarl]

Hello All,

I was running a query and could not remember the full expression I used when I entered the data so I tried running a query using only a partial wording that I knew to be correct. But I got no results when I ran the query. I found the correct wording and ran the query using again and it worked fine. Is there a wildcard or some way to enter a partial expression in the criteria column that will return results?

Thanks,

SC

[PYS]

Hi

Yes you can use LIKE and * as described in this FAQ on the wiki.

Some others interesting queries.

Regards

[Santacarl]

Thank you very much…Extremely helpful. I knew there had to be a way but I am so new to SQL that I got frustrated and did not even think of looking on the Wiki…DUH on me…

Best regards,

SC