Re: Simulating wildcard for Numeric database types

From: "Adam Maass" <adam.nospam.maass@xxxxxxxxxxx>
Date: Tue, 29 May 2007 21:47:06 -0700

"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.

.

Follow-Ups:
- Re: Simulating wildcard for Numeric database types
  - From: Robert Klemme

Prev by Date: Re: Newbie Needs Help !!!
Next by Date: Re: Simulating wildcard for Numeric database types
Previous by thread: Re: Newbie Needs Help !!!
Next by thread: Re: Simulating wildcard for Numeric database types
Index(es):
- Date
- Thread

Relevant Pages

Re: Simulating wildcard for Numeric database types
... On 30.05.2007 06:47, Adam Maass wrote: ... 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: T68bis "Minus Zero" potato amp circuit and layout now online
... but four parts and a bunch of extra work when one would ... "Looks trick". ... I thought the lesson here was KISS? ...
(rec.audio.tubes)
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)