Thanks. Yes I did actually here is the full syntax, but I still get the error code:

declare @trans_num as varchar(10)

declare @student as varchar(10)

select @trans_num = 'E7281649' --Nomination E number

select @student...