select right(('0000'+pageorder),3) from neworder

[NSMan]

When the following is typed in, I get these results...

select right(('0000'+pageorder),3) from neworder

4
5
6
7
8
9
10
11
12
13
ect...

I know this is something stupid and dumb, but I'm too tired to figure it out....

 

[bborissov]

Trim the field

select right(('0000'+rtrim(pageorder)),3) from door

Borislav Borissov

 

[SQLBill]

What's your question?

-SQLBill

Posting advice: FAQ481-4875

 

[bborissov]

No leading zeros in result, I suppose

Borislav Borissov

 

[SQLBill]

Could be......but then they would have to let us know what datatype pageorder is. If it's INT, then they are just ADDING the two numbers together and not concatenating them. 0000 + 4 = 4

If they want to concatenate the 0000 to the number, they need to convert pageorder (if it is an int) to VARCHAR.

But we can guess all we want....they know what they want and just need to let us know.

-SQLBill

Posting advice: FAQ481-4875

 

[bborissov]

Agree.
I just post a reply with all assumption I made about the type of the field

Borislav Borissov

 

[pmegan]

It looks like you're problem is with the data types. Try this:

select right(('0000'+cast(pageorder as varchar(3))),3)
from neworder

This assumes pageorder won't be over 999.

Pat

 

[Jasen]

you can just do cast(pageorder as varchar), rather than specifying 3 digits.