Remove trailing spaces and zero from a string in SQL-Server

Top Post on IndiBlogger
0

In this blog, I will discuss about “How to remove trailing spaces and zeros from a string without using any trim function”.I have written a procedure for the same. In one of my blog where I have shared the code for removing the leading zeros and spaces, here as well, code is almost the same. CREATE PROCEDURE [dbo].[RmTrailingZerosSpcs] (@String VARCHAR(500) )asBEGINDECLARE @output VARCHAR(100) =

Read this post on allabouttechnologies.co.in


Karan Arora

blogs from Chandigarh