Lynn Pettis - Friday, March 15, 2019 4:14 PM
Using your single value sample:
IF OBJECT_ID('dbo.TestSSNTrim','U') IS NOT NULL
DROP TABLE [dbo].[TestSSNTrim];
CREATE TABLE [dbo].[TestSSNTrim](
[OldSSN] varchar(11));
INSERT INTO [dbo].[TestSSNTrim]
(
[OldSSN]
)
VALUES
(
'235-55-7777' -- OldSSN - varchar(11)
);
SELECT
[tst].[OldSSN]
, LeftTrim = LEFT([tst].[OldSSN],4)
, RightTrim = RIGHT([tst].[OldSSN],4)
FROM
[dbo].[TestSSNTrim] AS [tst];
IF OBJECT_ID('dbo.TestSSNTrim','U') IS NOT NULL
DROP TABLE [dbo].[TestSSNTrim];
GO
OldSSN LeftTrim RightTrim
----------- -------- ---------
235-55-7777 235- 7777