Hi,

When I input the criteria in the View, it will show N before the word, what's that mean?

Hi there,

It does that by default because you may be using a unicode column such as nvarchar, if you are not using a unicode column then just delete the N manually.

Personally I wouldn't use the query designer, just use T-sql in query analyzer