> > Sure I could. Then in Delphi I would have
> > if eWHS.Text='' then
> > paramByName('WHS').AsString:=' ' else
> > paramByName('WHS').AsString:=eWHS.Text;
>
>
> or just:
>
> paramByName('WHS').AsString := eWHS.Text + ' '[1];
>
>
> Luc.
>

pure elegance Lucas... bet it runs fast too.
Alan