I create a table in my SQL server. one of columns named "userid" and its datatype is text. now i want this column as primary key. but i get a message saying " primary keyor index can&#039;t be created on column &#039;userid&#039; beacause its data type is text"<BR>then I try to convert data type from text to int, i get another message saying "conversion from &#039;text&#039; to &#039;int&#039; is not supported on the connected database server"<BR><BR>so how can i dandle this? i used Access before and i never experience such problem. thank you for your help!