Re: Simple SQL Question
From: <jehall_at_my-deja.com>
Date: Mon, 20 Mar 2000 16:59:08 GMT
Message-ID: <8b5lcj$j0j$1_at_nnrp1.deja.com>
Date: Mon, 20 Mar 2000 16:59:08 GMT
Message-ID: <8b5lcj$j0j$1_at_nnrp1.deja.com>
In article <8b5kgi$ice$1_at_nnrp1.deja.com>,
rtproffitt_at_my-deja.com wrote:
> I have used this approach before:
>
> Code the combo box so that a choice of ALL returns '%',
> or, if 'ALL' is returned, then add an If in the
> trigger to convert it to '%'.
> Then write the where clause: where X like :bind_var
>
> Robert Proffitt
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Okay Thanks!!!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 20 2000 - 17:59:08 CET