Click here to Skip to main content
16,021,041 members
Articles / Database Development / SQL Server / SQL Server 2014
Tip/Trick

A Simple Example of Microsoft SQL Server Pad String

Rate me:
Please Sign up or sign in to vote.
4.50/5 (9 votes)
18 Dec 2015CPOL 11.9K   5   5
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 19th, 2015: Initial post

License

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



Comments and Discussions

 
GeneralMy vote of 3 Pin
dmjm-h22-Dec-15 4:13
dmjm-h22-Dec-15 4:13 
QuestionA better version Pin
Darek Danielewski21-Dec-15 5:53
Darek Danielewski21-Dec-15 5:53 
AnswerRe: A better version Pin
Md. Marufuzzaman21-Dec-15 6:01
professionalMd. Marufuzzaman21-Dec-15 6:01 
GeneralMy vote of 1 Pin
Darek Danielewski21-Dec-15 5:35
Darek Danielewski21-Dec-15 5:35 
Very bad example of T-SQL. for one, it operates on varchar, which limits you to single-byte encoding. Second, limited to 16 characters only. Third, uses extra variable to pass the result back. Fourth, multiple checks for parameters passed in being NULL, with one of them changing the type of the original parameter.
If there was a way to give zero stars, I would.
GeneralRe: My vote of 1 Pin
Md. Marufuzzaman21-Dec-15 6:00
professionalMd. Marufuzzaman21-Dec-15 6:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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