How to create auto generate clientID as string + number?

Question

Hi,

I don't know mssql to create client ID like CLT001, CLT002.... like this as auto generate when insert query performing, In addition can I mark as private key.

 

 

 

I don't want the auto generate using identity  value from numeric ID, I need combination for clientID auto generation.

 

Additional information. 

I use Asp.net and Javascript, Ajax.