Cheesy one here
I created a view similar to
Select field1, field2 from table
where field3 = 'Fred'
UNION
Select field1, field2 from table
where field3 = 'Wilma';
When the view contains just one sql statement the field definitions e.g.
charater varying (20) however when both a
A team developer has chosen the lazy way of not checking if a variable
exists on his PHP page and has code which produces the following SQL
SELECT * FROM mytable where myfield ilike '%%'
I have noticed that this statement does not return null or empty myfield
records.
Is this the way (SQL) to do
