Variable in SQL Statement

Jeff Honken jhonken at
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")
into q

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 mailing list