Re: How can I conserve the initial zero when convert numeric to string using STR()
- From: "--CELKO--" <jcelko212@xxxxxxxxxxxxx>
- Date: 28 May 2006 08:37:44 -0700
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.
.
- Follow-Ups:
- Re: How can I conserve the initial zero when convert numeric to string using STR()
- From: Tony Rogerson
- Re: How can I conserve the initial zero when convert numeric to string using STR()
- From: Erland Sommarskog
- Re: How can I conserve the initial zero when convert numeric to string using STR()
- References:
- Prev by Date: Re: T-SQL CLOSE Connection to DB
- Next by Date: Re: How can I conserve the initial zero when convert numeric to string using STR()
- Previous by thread: Re: How can I conserve the initial zero when convert numeric to string using STR()
- Next by thread: Re: How can I conserve the initial zero when convert numeric to string using STR()
- Index(es):
Relevant Pages
|
