[GENERAL] Empty String Field

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? Mit freundlichen Grüßen / Best regards Robert Esser mit Consulting München [EMAIL PROTECTED] (please remove no_spam_)

Re: [GENERAL] Empty String Field

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