Hi Sir,
i have implemented the exercise on page 412,413. Everything is good. But there is a query. When I put the filter LIKE'%rock%', then in my filter column LIKE'%rock% changes to LIKE N'%rock%'. And similarly in my SQL pane (Name LIKE N'%rock%') was written.
I don't understand why this word 'N' is written all though you don't mentioned any thing about it in the book.

Please guide.

Hi there,

VWD adds the N to mark the value that follows it as Unicode. Check out these links for more details:

LIKE N'%rock%' Chap 12 - Page 413, #6
'N' prefix in SQL statements ?
http://databases.aspfaq.com/general/...-n-prefix.html

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!