-----Original Message-----
From: Jason Reichenbach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:37 PM
To: CF-Talk
Subject: RE: SQL: Passing vars to a LIKE statement
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]
