Hello,

I am at the page 413 of your book Imar. At the number 6. You tell us to write LIKE '%ROCK%' in the Filter case in the criteria pane.

When im writting this ... VWD add an 'N' before '%ROCK%' which result into LIKE N'%ROCK%'.. you don'T seem to mention anything regarding this N letter appearing.. even if i remove it.. it still re-add it to the filter LIKE statement. I can only correct this in the SQL Pane.

Just wondering what going on ?

Thanks.

Hi Rushino,

The n prefix makes the text following it Unicode. The query designer does this by default.

For more info: http://databases.aspfaq.com/general/...-n-prefix.html

In most cases, you can safely ignore it....


Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks! :)

Yeah, thanks.. this was bugging me as well.

Same here, Thank you ^_^