5 digit zipcode

I am trying to display just the first 5 digits of the zip code. How can I do
this?
ThanksOn Jul 9, 2:34 pm, Shan <S...@.discussions.microsoft.com> wrote:
> I am trying to display just the first 5 digits of the zip code. How can I do
> this?
> Thanks
Try =Fields!FieldName.Value.Substring(0,5)|||Thanks it worked.
"Jen" wrote:
> On Jul 9, 2:34 pm, Shan <S...@.discussions.microsoft.com> wrote:
> > I am trying to display just the first 5 digits of the zip code. How can I do
> > this?
> >
> > Thanks
> Try =Fields!FieldName.Value.Substring(0,5)
>|||Thanks it worked.
"Jen" wrote:
> On Jul 9, 2:34 pm, Shan <S...@.discussions.microsoft.com> wrote:
> > I am trying to display just the first 5 digits of the zip code. How can I do
> > this?
> >
> > Thanks
> Try =Fields!FieldName.Value.Substring(0,5)
>|||you can also use Left(fieldname, 5)
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:59473B89-F8DE-4B44-8C6F-E7B0C96AC3C0@.microsoft.com...
>I am trying to display just the first 5 digits of the zip code. How can I
>do
> this?
> Thanks

36 digit number

Hi I have this column numbers as varchars.
Length is 36
I need them to be numeric so I can run calcs on them
I can't find a datatype that allows that.
what the heck?
thanksTry with decimal.
Example:
declare @.d decimal (36, 0)
set @.d = 999999999999999999999999999999999999
select @.d
go
AMB
"Candor Feg" wrote:

> Hi I have this column numbers as varchars.
> Length is 36
> I need them to be numeric so I can run calcs on them
> I can't find a datatype that allows that.
> what the heck?
> thanks
>
>|||Lookup NUMERIC and DECIMAL data types in SQL Server Books Online.
Anith|||Just out of curiosity, what is being represented as a 36 decimal number?
"Candor Feg" <ddsd*f.com> wrote in message
news:i9KdnbbWotCeOAnfRVn-tA@.comcast.com...
> Hi I have this column numbers as varchars.
> Length is 36
> I need them to be numeric so I can run calcs on them
> I can't find a datatype that allows that.
> what the heck?
> thanks
>|||The chances of me being the antichrist.
"JT" <someone@.microsoft.com> wrote in message
news:%23lFGkfVYFHA.3132@.TK2MSFTNGP09.phx.gbl...
> Just out of curiosity, what is being represented as a 36 decimal number?
> "Candor Feg" <ddsd*f.com> wrote in message
> news:i9KdnbbWotCeOAnfRVn-tA@.comcast.com...
>