Posted by angellian on 05/28/06 04:31

Sorry to raise a stupid question but I tried many methods which did
work.
how can I conserve the initial zero when I try to convert STR(06) into
string in SQL statment?
It always gives me 6 instead of 06.

Thanks a lot.

• Next in forum: T-SQL CLOSE Connection to DB
• Prev in forum: sufficient user permissions for install error
• Thread view: How can I conserve the initial zero when convert numeric to string using STR()

[Reply to this message]