Please run this query:
declare @extension varchar(100),
@Code varchar(500),
@originalstring varchar(100)='[NTP-228].Test'
SET @extension = SUBSTRING(@originalstring, CHARINDEX('.', @originalstring)+1, 999)
set @Code=SUBSTRING(@originalstring,0, CHARINDEX('.', @originalstring))
select @extension,@Code
Ashish