Toad World® Forums

Query with IN and LIKE

I would like to know if it is possible to do a query using the DIAGRAM tab and simultaneously use the parameters IN and LIKE. I have field that has a bunch of preceeding zeros so I need to use the LIKE with “Ends With”, but I would also like to search for mulitple records in that field with IN. Thanks for your help.

If you are talking about the "Query Builder" and its Diagram tab then just click '...' in the "Where" row and type your formula in the populated dialog.
Look at screenshot for details.