Hi All. I'm creating a Users Table which contains a Password field that I wish to make case sensitive. By default the database I'm working on is Case Insensitive. I cannot access the server with a management tool so this has to be done through code. I know that I have to use the Collate keyword but I'm unsure of the correct syntax.
My create statement is as follows;
CREATE TABLE AppUsers(UserId smallint NOT NULL,UserName varchar(255),UserPword varchar(8))