dsoderstrom
asked on
Question regarding SQL Query Editor
I am designing a query using the Query Editor in SQL server.
I am querying a table and putting a filter on a nvarchar column.
If I type a value into the filter column, for example '12', the editor changes it to N'12'.
why is it doing this? What does the "N" signify?
I am querying a table and putting a filter on a nvarchar column.
If I type a value into the filter column, for example '12', the editor changes it to N'12'.
why is it doing this? What does the "N" signify?
ASKER
So, can I strip out this N and get the same results?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, thanks for the info Jim
Typically this is needed when dealing with foreign language collations.
>If I type a value into the filter column, for example '12', the editor changes it to N'12'.
Curiosity overwhelms me ... if you have a column that you'd want to filter on '12', then why is it a character data type as opposed to numeric?