Hi All

I am creating what I though to be a simple search function. I am using asp.net2 (VB) as my from end which pass some parameters into an stored procedure and what I am trying to do is concatenate 2 wildcards (%) either side of my parameter rather than the user adding the wildcards.

Here is what I thought would work but it give me the error:

invalid operator for data type. Operator equals add, type equals ntext

Code:

I am pretty new to all of this still and sometime make things up as I go along.. this being the case with the above.

Can anyone one see where I am going wrong or suggest an alternative?

Ta

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

You have to change the data type of your @field1param from ntext to nvarchar because the string concatenation operator (+) is not allowed on text/ntext data types.

SQL Server Helper
http://www.sql-server-helper.com