how can i auto generate such type of series in sql server 2000

considering a table named as - 'table_name'
and having columns- 'Patient_Type', 'Patient_ID'

i will suggest the following solution

select 
result=case Patient_Type 
       when 'Normal' then 'ln0000'+Patient_ID 
       when 'LAMA' then 'L0000'+Patient_ID 
       end
       from table_name 

Please check and mask as answer if it works.