by Dinesh.T. » Sat, 26 Jul 2003 23:04:26
N (as in National language..) indicates that whatever follows is a unicode
string.See
INF: Unicode String Constants in SQL Server Require N Prefix
http://www.support.microsoft.com/?id=239530
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
Quote:> Hey all,
> I came across a SQL: select * from customer where Name <>
> N'Tom'. What does "N" mean in this case?
> Thanks
> David
1. Analyse search condition before sending it to SQL
Hi folks!
I have a search page written with ASP that calls a stored procedure that
does the full-text search on the SQL 2000 database. Is there an analyser
that prepares the string for SQL since when I type in "my name" (without
quotation marks) SQL reports an error.
Cheers from Sarajevo,
Adnan
2. CoInitialize error in Enterprise Manager
3. Using variables or field name as a search condition (SQL 7.0)
4. Problem connecting Oracle Webserver with Net80?
5. Help!! Length of Search Condition String
6. Deleted records suddenly reappeared
7. Full-Text Search Condition Syntax Checking
8. Case-INSENSITIVE searches?? Possible??
9. Conditional search condition
10. Joining on search condition
11. Reg limitation in the search condition in FREETEXTTABLE predicate
13. Variable Search Condition within a SP