SQL: Passing vars to a LIKE statement

[Eric Creese]

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?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---