On 22 Ago, 11:04, sybrandb <sybra..._at_gmail.com> wrote:
> On Aug 22, 8:47 am, Fab FaRa <fabrizio.far..._at_email.it> wrote:
> The usual trick is
> select name
> from mytable
> where name like :Myname||'%';
> Just leave Myname blank and you will get everything
>
> The wildcard for multiple characters is '%'
> This can easily be looked in the sql reference manual athttp://tahiti.oracle.com
> and you shouldn't ask for it here.
Hi and thanks for your help!
Received on Wed Aug 22 2007 - 05:39:27 CDT
