haha i literally picked that up just before i had your reply

but many thanks anyway

how can i convert a string to a datetime

well heres the only reference to key in the script

create table #shortlist (spid varchar(12) COLLATE SQL_Latin1_General_CP1_CI_ASprimary key);