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