extract last ID and add to it in SQL
===

I am doing a project in C# using SQL as backend.

I want to insert a code in SQL eg ABC001, where ABC comes from the COMPANY table and the 001 is done wrt to emp_id from EMPLOYEE table i.e. last ID+1 but in the form of 001,002...999.

How can I do the ID+1 part of it?

