pcsoft.us.windevCopyright 2026, PC SOFT25 Nov 2015 16:39:53 Z25 Nov 2015 16:39:53 ZHello, I Use Windev 20. I like to use SQL instruction "FIND in SET" for rangking some items in my report. Now it is only working in the ODBC Query 5.5 mode??. I want use it in a query off the project for HFSQL . How to do it?. Here my Sample Code: FIND_IN_SET(M, ( SELECT GROUP_CONCAT(M ORDER BY M ASC ) FROM pursuitwom12 ) ) AS R1 , FIND_IN_SET(MM, ( SELECT GROUP_CONCAT(MM ORDER BY MM ASC ) FROM pursuitwom12 ) ) AS R2 FROM pursuitwom12, status where print="P" AND Status.StId = Category ORDER BY MMM ASC Regards, WIm Kuiper.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55138-windev-report-sql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)