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 this?? Is there a better syntax to the SQL?? Is the better way to create the statement in PHP is to check if the passed value <> '' ?? Or is this issue being fixed in the new V8 version of postgreSQL. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
