Technical Article

Yet Another Pad Utility

,

Usage:
SELECT dbo.PadValue('TEST', 5, '*', 0)
Returns: '*TEST'

/********************************************** 
Title: fn_PadValue
Programer: Mike DiRenzo 
Date: 1/6/2005 
Called By:

Params: 
@inVal varchar(50) - The original value to be padded
@PadLimit int - The limit of padding to apply

For example, if the limit is 5 and the original length
of the value is 3, then the applied padding will be 2 chars.

@PadChar char(1) The padding char. It could be anything. Default is '0'
@PadSide int The side in which the padding is tobe applied.

For example, 0 is Left, 1, is Right, default is Left
Returns: Padded version of original value

Usage: 
SELECT dbo.PadValue('TEST', 5, '*', 0) 
Returns: '*TEST'
**********************************************/ 
Create FUNCTION dbo.fn_PadValue
(
  @inVal varchar(50), 
  @PadLimit int, 
  @PadChar char(1), 
  @PadSide int
)
RETURNS varchar(50)
AS
BEGIN
  Declare @retVal varchar(50)
  Declare @Padding int
  --Determine the amount of padding
  Set @Padding = @PadLimit - Len(@inVal)
  IF @Padding < 0
    Set @Padding = 0

  IF @PadSide = 0 -- Pad the left side
    Set @retVal = Replicate(@PadChar, @Padding) + @inVal

  IF @PadSide = 1 --Pad the right side
    Set @retVal = @inVal + Replicate(@PadChar, @Padding) 

  RETURN (@retVal)
END

Rate

3 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

3 (1)

You rated this post out of 5. Change rating