Tuesday, May 28, 2024

Remove First 3 character

 Declare @str nvarchar(23) = '04.99991.03.001.00101'

SELECT RIGHT(@str, LEN(@str)-3)


Result: 99991.03.001.00101


No comments:

Post a Comment

Screen Record

 Windows Screen Record WindowsKey+ Alt + R Recording Starts.