Posted by Plamen Ratchev on 02/12/07 21:17

....it has been a long day already :)

On the last one you do not need the extra CAST:

SELECT RIGHT('0000' + CAST(1 as varchar), 4)

or,

SELECT RIGHT('0000' + CAST(code as varchar), 4) FROM Employes

Plamne Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Callable statements, SQLServer and JRun
• Prev in forum: Re: SQL Format Function "0000"
• Thread view: Re: SQL Format Function "0000"

[Reply to this message]