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.
| Author |
Topic |
|
mike.sql
Starting Member
1 Post |
 Posted - 2005-06-27 : 12:20:59
|
| SELECT field1 FROM table1 WHERE field1 = N'Yes' where field1 is a text field.what does the N before the 'Yes' signify.I'm am looking at a SQL view via sp_helptext command and I'm seeing something like this for all the text field criteria.thanksMike |
|
|
Sully
Starting Member
30 Posts |
Posted - 2005-06-27 : 12:46:59
|
| This indicates a Unicode constant, you can look it up in BOL...Stuck in neutral in a pedal to the metal world,Sully |
 |
|
|
|
|
|
has anyone ever seen this?