SQL Script Nvarchar Error

Hi,

Not sure if this is the correct forum as it relates to both SQL Express and VB Express?

Can you help with this please:

Using SQL Server Management Studio Express I can write the following SQL script which allows me to search the description column for data that contains the word "display". The declare @filter nvarchar(5) lets me set a fuzzy search level, how many characters need to match in the word.

This works fine, and changing the nvarchar(5) value allows me change the number of characters that need to match.

use ssop

declare @filter nvarchar(5)

set @filter='display'

select stockid,description

from stock

where description like '%' + @filter + '%'

The issue:

Within VB Express TableAdapter configuration wizard I can script the following and it works, however, I am unable to script the nvarchar(5) , how would I add this function into the script below?

SELECT stockID, partNo, description, qty, unitcost, location, min, image, date
FROM stock
WHERE (description LIKE '%' + @filter + '%')

Thankyou in advanced

RON