PDA

View Full Version : Odd 'Where' statements



beegeebluebo
03-25-2010, 10:29 AM
I'm familiar with SQL syntax but have not used SQL Server before. I am using 2008 Enterprise.

I used Filter in the Designer Editor. In my text field I put the string Abel. I ran the query and it found the record but Im baffled with the synbatx generated:

WHERE (LastName = N'Abel')

Where's the N come from?

Thanks

Bob Phillips
03-25-2010, 05:27 PM
N just means it is unicode strings.