declare @s varchar(max);set @s = 'fj/2016815/2016081553677565.pdf';select right(@s, charindex('.',reverse(@s))) AS 'aa'