sql datatype help

[himani]

hello,
i m having a problem with the sql database.it does not accept 0(zero)as
the first number in the integer field.whenever i insert 01 it takes it
as 1.similarly for 02 and so on till 09.i want 01. can anyone suggest
how to get.i m doing this on sql server.does sql server support?is this
the problem of sql server?

[Jens]

it impplicit cast the value to an integer. An integer with a trailing 0
isn´a integer, because this is a string. So you should store that as a
char / varchar type to presume that information (same here in germany
after the redesign of the zip code which afterwards contained trailing
zeros)

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

[Simon Hayes]

1 is an integer, '01' is a string. If you want to pad your integers
with leading zeroes, it would be best to do it on the client side, as
that's usually the best place for presentation and formatting. If you
really need to do it when you retrieve the values from the database
then this is one possible way:

select
case when IntColumn between 0 and 9 then '0' + cast(IntColumn as
char(1)) else cast(IntColumn as varchar(10)) end
from dbo.MyTable

Simon

[himani]

thanks for ur suggestion.

Jens wrote:

it impplicit cast the value to an integer. An integer with a trailing 0
isn´a integer, because this is a string. So you should store that as a
char / varchar type to presume that information (same here in germany
after the redesign of the zip code which afterwards contained trailing
zeros)

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

[himani]

hi Jens,
thanks for ur suggestion.

Jens wrote:

it impplicit cast the value to an integer. An integer with a trailing 0
isn´a integer, because this is a string. So you should store that as a
char / varchar type to presume that information (same here in germany
after the redesign of the zip code which afterwards contained trailing
zeros)

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---