A Simple Example of Microsoft SQL Server Pad String

Md. Marufuzzaman

Rate me:

4.50/5 (9 votes)

18 Dec 2015CPOL

11.1K

A simple example of Microsoft SQL Server Pad String

Introduction

An easy way to Pad String using Microsoft SQL Server.

Using the Code

A sample code snippet is given below:

SQL

//
CREATE FUNCTION [dbo].[FUN_pad_string] 

(
	@p_seq VARCHAR(16),
	@p_pad_with CHAR(1),
	@p_pad_length INT
) 

RETURNS VARCHAR(16) AS

BEGIN 

DECLARE @g_current_seq varchar(16)

SELECT @g_current_seq = ISNULL(REPLICATE(@p_pad_with, @p_pad_length - LEN(ISNULL(@p_seq ,0))), '') + @p_seq

RETURN @g_current_seq

END
//

Conclusion

I hope you get the scenario and this might be helpful to you. Enjoy!

History

Saturday, December 19^th, 2015: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CREATE FUNCTION dbo.PADLEFT ( @source NVARCHAR(4000) , @pad NCHAR(1) , @length INT ) RETURNS NVARCHAR(4000) BEGIN IF @source IS NULL OR @pad IS NULL RETURN NULL; RETURN RIGHT(CONCAT(REPLICATE(@pad, @length),LTRIM(RTRIM(@source))), @length); END;

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.