SQL Blog - Pieter van Maasdam, Macaw - All Comments

SQL - Wrong results in Isoweek function

SQL Blog - Pieter van Maasdam, Macaw — Tue, 24 Feb 2009 12:45:24 GMT

Madhivanan — Mon, 19 Nov 2007 11:05:46 GMT

Well. Another method

SELECT

m.MemberId,

RIGHT(POWER(10,5)) + m.MemberId, 5) AS MemberCode

FROM Member m

Repieter — Mon, 19 Nov 2007 09:36:22 GMT

Agreed.. It's better to change the number of replications to 5 in this case.

I didn't have to deal with negative numbers here so this will not occur, but thanks for pointing this out.

Madhivanan — Mon, 19 Nov 2007 09:06:36 GMT

But if you want to show the data in front end, then I prefer formatting there

tonyrogerson — Sat, 17 Nov 2007 11:33:50 GMT

Don't forget this method doesn't deal with negative numbers - it makes them invalid; you get 00-123 instead of -00123.

Tony.

simonsabin — Fri, 16 Nov 2007 09:59:13 GMT

It is better to onlt replicate the number of 0s you need. So in your case change 10 to 5.

Wed, 14 Nov 2007 23:20:51 GMT