Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Why the N in the WHERE-clause

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-11 : 08:52:45
Kajsa writes "Hi!

This is a probably a silly question but I'm still wondering...

Why shuld you use N in a WHERE-clause?

Is it better, in any why, to write:
SELECT * FROM Project where Descr LIKE N'%InterDev%'
than
SELECT * FROM Project where Descr LIKE '%InterDev%'
???

/Kajsa"

Nazim
A custom title

1408 Posts

Posted - 2002-02-11 : 08:57:51
check this link it should help you understand the use of N.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12792



--------------------------------------------------------------
"Happiness is not something you experience, it's something you remember."
Go to Top of Page
   

- Advertisement -