> I think you have multiple issues with this SQL Statement. I was wrong. I didn’t fully understand the SQL statement at the time of my last reply, upon further inspection it seems the SQL is valid (apart from the missing : in the variable reference).
There must be something else wrong, like using this statement inside of a SQL function {fn} call for example. I think we are missing some context about how you are using this method, because executing this code in a method by itself is working in a sample database here. -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************