Posted by --CELKO-- on 05/28/06 18:37

You are confusing the PHYSICAL display with the internal LOGICAL model.


This is SQL and not COBOL. There is no initial zero in a number; there
is an internal binary, BCD or whatever the hard uses representation.

Your next problem is that you do not understand that dispaly is NEVER
done in the database, but in the front end application. That is the
most basic concept of *any* tiered architecture, not just SQL.

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

[Reply to this message]