Home Forums SQL Server 2005 Administering extact last 3 characters from a string RE: extact last 3 characters from a string
J-F Bergeron
SSCrazy Eights
Points: 8593
More actions
October 14, 2009 at 4:46 am
#1065579
Does this help?
DECLARE @STR NVARCHAR(10)
SET @STR = 'ABCDEFGHI'
SELECT substring(@str, 1, len(@str) - 3) + ' ' + right(@str, 3)
Cheers,
J-F