Re: Simple SQL Question
From: <rtproffitt_at_my-deja.com>
Date: Mon, 20 Mar 2000 16:44:07 GMT
Message-ID: <8b5kgi$ice$1_at_nnrp1.deja.com>
Date: Mon, 20 Mar 2000 16:44:07 GMT
Message-ID: <8b5kgi$ice$1_at_nnrp1.deja.com>
[Quoted] 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.
Received on Mon Mar 20 2000 - 17:44:07 CET