Robert Esser wrote:
>
> How can I check an empty string field with a query?
>
> If I make a select ... where fieldname ='' then I get no result!! What is
> the right way?
If you mean a field with a null value (nichts drin) then use
where fieldname IS NULL
>
> Mit freundlichen Grüßen / Best regards
Auch einen Gruss /Greetings
Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: [EMAIL PROTECTED]
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
