Advertisement

08.07.2007 at 06:12AM PDT, ID: 22746407
[x]
Attachment Details

How do I left pad a string expression with zero's?

Asked by ipendlebury in MS SQL Server

Tags: MS, Sql Server, 2000

In an sp i'm writing, I need to convert an integer value to a string. I usually do this with the cast() function. But this time, I need to left pad the string with zeros. So how do I do this?

IanStart Free Trial
[+][-]08.07.2007 at 06:20AM PDT, ID: 19645432

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: MS, Sql Server, 2000
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 3
Solution Grade: A
 
 
[+][-]08.07.2007 at 06:20AM PDT, ID: 19645433

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]08.07.2007 at 06:20AM PDT, ID: 19645434

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]08.07.2007 at 06:32AM PDT, ID: 19645541

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628