I have a column in a SQL Server database called position and it is nchar(20).
When I add text into the column using SQL Server management studio, it appears to put spaces onto the end of the data
This means that "Director" becomes "Director " (just adding " to show what I mean.
When I go to select from position colum where position = "Director" it does not find the record.
How do I stop these extra spaces being added ?