first.
> -----Original Message-----
> From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 20 februari 2004 11:57
> To: CF-Talk
> Subject: Re: [cftalk] RE: Stored Procedures
>
> I have simplified this to:
>
> But get error [Macromedia][SQLServer JDBC
> Driver][SQLServer]Line 1: Incorrect syntax near 'a'.
>
> Any more help please?
> Allan
> --------------------------------------------------
>
> CREATE PROC GetMessages2
>
> @searchtext varchar (100)
>
> AS
>
> DECLARE @query varchar(1000)
>
> SET @query = 'SELECT * FROM Messages'
>
> SET @query = @query + ' WHERE 1=1'
>
> IF @searchtext <> ''
> SET @query = @query + 'AND Message LIKE' + '%' + @searchtext + '%'
>
> EXEC(@query)
> GO
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
