I have the following check constraint on an NVARCHAR(255) column:
([weekReviewWk10]='A' OR [weekReviewWk10]>=(0) AND [weekReviewWk10]<=(25))
However, when someone enters, say, 23.5, SQL Server rejects the input. How can I fix this? I know it is because it is testing things as
ints, but how do I get it to test the entry as a decimal?
The column has to be NVARCHAR since, as you can see, I also need my users to be able to enter 'A'.