Re^2: DBI match both empty and undef

SQLite and MSSQL. Both make a difference between undef and empty, and I would like to match both.

Comment on Re^2: DBI match both empty and undef

Replies are listed 'Best First'.
Re^3: DBI match both empty and undef by pme (Monsignor) on Jan 27, 2019 at 16:15 UTC
`SELECT * FROM GlossaryMetadata WHERE (Tag1 is null or Tag1 = '') AND ( +Tag2 is null or Tag2 = '');` [download]	[reply] [d/l]