pcsoft.us.windevCopyright 2026, PC SOFT30 Jan 2016 01:35:00 Z28 Jan 2016 17:13:00 ZHi, I have in my hand a SELECT query created by the editor. Is there a way to add another "boolean-like" condition in which the result includes (or not) the records that have that certain field as NULL? i.e. I have a table "students" with these records: id |name |grade 1 |Alex |C 2 |John |NULL and a simple query like this: SELECT id,grade FROM students What I need is a way to have a SELECT query that, given the "boolean-like" condition passed as a parameter (let's say, in the HExecuteQuery() function), it will include the record "2|John|NULL" (or won't include, if the condition "IS NULL" is set to FALSE). Ps. it is very important for me to do this in a single query, as this is one of the requirements that must be respected Thanks, Dann30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56160/read.awp30 Jan 2016 01:35:00 ZSimply use COALESCE(grade,0) and then look for 0 (or whatever value you decide to use in the COALESCE statement)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56160/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56160/read.awpQuery with condition "IS NULL" parametricguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56158/read.awp29 Jan 2016 19:20:00 ZI think he wants to turn off an IS NULL condition. If it is a = {param} condition you can set param to NULL for turning off the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56158/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56158/read.awpQuery with condition "IS NULL" parametricguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56148/read.awp29 Jan 2016 17:13:00 ZQuote Stefan Bentvelsen Hi Dann, may be, you can add a statement CASE WHEN grade is null THEN 0 ELSE 1 END AS Gra…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56148/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56148/read.awpQuery with condition "IS NULL" parametricguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56108/read.awp28 Jan 2016 21:16:00 ZHi Dann, in such cases I do not use the query editor, but hexecutesqlqeuery- So I can build my SQL string by code. Best…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56108/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-with-native-56108/read.awpQuery with condition "IS NULL" parametricguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56107/read.awp28 Jan 2016 17:35:00 ZHi Dann, may be, you can add a statement CASE WHEN grade is null THEN 0 ELSE 1 END AS GradeEvaluated and add a WHERE GradeEv…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56107/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56106-query-with-condition-quotis-nullquot-parametric-56107/read.awpQuery with condition "IS NULL" parametric