-----Original Message-----
From: Brett Barnhart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:22 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
> I need to pass some varibles into a LIKE clause in a SELECT statement.
> I am having trouble with the format.
>
> AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
> is wrong cause it see that garb as a literal string. How do I pass
> this so the vars
show?
Here is what I am doing now... may be a better way...
lower(ki.Question) like lower('%#form.KeywordSearch#%')
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
