Variable in SQL Statement
jhonken at webdsp.com
Mon Feb 5 17:30:19 EST 2007
I've been trying to put a wildcard "%" into a SQL statement that
contains a variable. I just can't seem to find the right format.
Here's the SQL statement:
put revQueryDatabase(gConID, "SELECT ClaimNum FROM AccountEntry WHERE
ClaimNum LIKE '" & QueryDate & "'&% ORDER BY ClaimNum DESC LIMIT 1")
I've tried the &% and various other combinations with no luck. Can
someone please point me in the correct direction for this statement.
More information about the Use-livecode