Skip to main content

TSQL : Getting last part of the a parameterized string

DECLARE @Filename varchar(max) = 'VXXF-107_v.12 - CA Sample~{baliw.me@facebook.com}~22f70d68-aa34-4ce9-bb3d-2ac65f9ca3a9.xml'

SELECT RIGHT(@Filename, CHARINDEX('~', REVERSE(@Filename)) - 1) 

Comments