pcsoft.us.windevCopyright 2026, PC SOFT13 Jul 2018 19:38:00 Z13 Jul 2018 14:12:00 ZGood day How can you use a parameter inside a query in a CASE statement. I.e. I want to pass a parameters {Period} = 2 as a field in the query and then se that in a case i.e. CASE WHEN Period = 1 then blah blah else blah blah END So my query reads: SELECT xyz, 1 as Period, CASE WHEN Period = 1 etc. etc. from tablename Thanks in advance Ericus Steyn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66154-21-sql-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66154-21-sql-query-solved-found-workaround-66157/read.awp13 Jul 2018 19:38:00 ZMaybe to try with sSQL is string = "SELECT xyz, 1 as Period, CASE WHEN Period = %1 etc. etc. from tablename" StringBuild(sSQ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66154-21-sql-query-solved-found-workaround-66157/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66154-21-sql-query-solved-found-workaround-66157/read.awp[WD 21]SQL Query