Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chibis
Starting Member
1 Post |
 Posted - 2009-04-08 : 15:57:00
|
| Hello everybodyI have a text field which should allow only unique values. I don't want to make it varchar, since I don't know the length of the values. To make things worse, it must be case sensetive. So that 'aids' and 'aids' is not allowed, but 'AIDS' and 'aids' isIs there any way to acomplish this.Thank you. |
|
|
dsindo
Starting Member
45 Posts |
Posted - 2009-04-21 : 21:18:20
|
| just add a New field set it as binary populate it with then set as primary key.select cast('aids' as binary) select cast('AID' as binary) 0x6169647300000000000000000000000000000000000000000000000000000x414944000000000000000000000000000000000000000000000000000000 |
 |
|
|
|
|
|
setting text field to hold unique values