I'm assuming you are posting from a form or the like and calling this
SP.

Pass this from your cf page when you call the Sp

@yourspvar = formvar&"%"

That way the @yourspvar is a string when it comes into the sp and no
need to do any of the % or single quotes in your SP just simply use
whatever LIKE @yourspvar
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to