Variable in SQL Statement

[Ruslan Zasukhin]

On 6/2/07 12:30 AM, "Jeff Honken" <jhonken at webdsp.com> 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
http://www.paradigmasoft.com

[I feel the need: the need for speed]