Strips out the N prefix and single quotes from a string if they exist so that a value like N'Active' becomes Active
Strips out the N prefix and single quotes from a string if they exist so that a value like N'Active' becomes Active