Variable in SQL Statement

Ruslan Zasukhin sunshine at
Mon Feb 5 17:37:22 EST 2007

On 6/2/07 12:30 AM, "Jeff Honken" <jhonken at> wrote:

> 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

So you final string will looks as:

    WHERE ClaimNum LIKE '199'% ORDER BY
But it should be 

    WHERE ClaimNum LIKE '199%' ORDER BY

> I've tried the &% and various other combinations with no luck. Can
> someone please point me in the correct direction for this statement.

Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information

[I feel the need: the need for speed]

More information about the Use-livecode mailing list