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. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
