MS-SQL: unique constraint case-insensitive
Yes a computed column would achieve this for you. Or you could create an trigger that will fire on insert or updates. Here is link to a question like yours on stackoverflow.