Re: SQL: Passing vars to a LIKE statement

[Brett Barnhart]

> 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]

---