Código SQL [-] SELECT 'S00'+CONVERT(CHAR,CONVERT(INT,SUBSTRING([Clave_Libro],2,6))-2) AS [Clave del Libro] FROM TABLA
SELECT 'S00'+CONVERT(CHAR,CONVERT(INT,SUBSTRING([Clave_Libro],2,6))-2) AS [Clave del Libro] FROM TABLA