Par2: SQL alternative to CHOOSE 2007-12-09 -- Jim Gambon > I know that I can use Choose to return different fields from a TPS file on a > condition. > > Is there a similar functionality that will work inside a Prop:SQL(Select ... > operation? Check out the use of "CASE" in a Select statement. It usually works something like this (I may not have the syntax exactly correct): SELECT CASE "fieldToTest" WHEN 'A' THEN 'Blah' WHEN 'B' THEN 'BlahBlah' WHEN 'C' THEN 'WhoZits' ELSE 'Nada' END AS "ColName" FROM "tablename" Printed April 30, 2024, 1:45 am This article has been viewed/printed 35123 times. |