How to generate Id with characters

DECLARE @ID VARCHAR(50)
SET @ID=SELECT 'CST'+CONVERT(VARCHAR,ISNULL(MAX(CONVERT(NUMERIC,SUBSTRING(ID,4,4))),1000)+1) FROM CUSTOMER

CST-STRING TO ADD WITH ID
CUSTOMER-TABLE NAME

INSERT INTO CUSTOMER(ID)VALUES(@ID)