Re: Simulating wildcard for Numeric database types

On 30.05.2007 06:47, Adam Maass wrote:

"goykhmanster" <goykhmanster@xxxxxxxxx> wrote:
Nevermind, i figured it out.. TO_CHAR(COLNAME) LIKE '%' does the
trick.

But that makes me shudder. Unless the DB's query optimizer is very smart, this will result in a lot of extra work. Much better to dynamically generate the SQL.

Absolutely! Then the only problem left is to get the indexing right. :-)

robert
.

Relevant Pages

  • Re: Simulating wildcard for Numeric database types
    ... trick. ... But that makes me shudder. ... Unless the DB's query optimizer is very smart, this will result in a lot of extra work. ...
    (comp.lang.java.databases)
  • Re: Red gingham is so hot
    ... missing a trick here...! ... pants on the bottom half <shudder>) and tell them the bigger you are the ...
    (uk.people.consumers.ebay)