Hi All
I am trying to creat a unique index, however I get an error when I try to compile the following statement. What am I doing wrong?

CREATE UNIQUE CLUSTERED INDEX House_Hold_ind
ON TempTbl Upper(Substring(lname,1,10) + Substring(ad1,1,1) +
Substring(Zip,1,3))


Thanks