generate id and increase

select 'Mygo00'+cast(max(substring(eid,6,4)+1) as varchar(25)) from registration

~~~~~~~~~~~~~~~~~~~~~
Ragards..

Vijay