pcsoft.us.windevCopyright 2026, PC SOFT11 Nov 2014 20:34:00 Z11 Nov 2014 20:01:00 ZHi, I would like to sort on a calculated item in a query. The calculated item should be True or False based on equality of two numeric items in the query: File1.Item1=File1.Item2 I cannot find a syntax that is accepted by the query editor, neither in SQL nor in WL code. A simple File1.Item1=File1.Item2 won't do. I got as far as ABS(File1.Item1-File1.Item2), but I need the result to be strictly True or False. Any ideas? Regards, Piet30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48906/read.awp11 Nov 2014 20:34:00 ZPerfect, thanks Derek!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48906/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48906/read.awpSQL Questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48905/read.awp11 Nov 2014 20:16:00 ZPiet Can you not use a CASE statement? CASE WHEN File1.Item1 = File1.Item2 THEN 1 ELSE 0 END and sort on the resulting …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48905/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48904-sql-question-48905/read.awpSQL Question