Sql Server 2000 Identity Search

i am using this search


SELECT IDENT_CURRENT('t_Que') AS Expr1


and it will not return anything my primary key is a varchar with the length 12


will this command only work for an int as a primary key


and if so is there another way i could do this


my plan is to retrieve the last entered primary key so that i can generate a new one to add a new record to the database. the primary key is created by YYMMDDNN where


YY=year


MM=Month


DD=Day


NN=the number created that day





now just to be specific i dont need help creating the primary key i just need to know how to retrieve the previously created primary key.


I am trying this command directly in an sql query there is no code yet i am trying to see how the command functions first