Generate Auto increment HR_iD like COMP/MY/101

Question

Hii,

 

I want to create auto incremented hr_id I have fetch Max(hr_id)

but how to incease numeric portion in C# code.

 

Please Tell Me.

 

The MAX(HR_ID) is COMP/MY/101

 

when I do entry in table automatically it be

 

COMP/MY/102

 

for other COMP/MY/103 and so on...