Change number to character

Yahoo Archive
1
Thanks everybody!

Worked Great!!

Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Thursday, July 03, 2003 11:25 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Change number to character



STRING(OrderRel.OrderNum, ">>>9")

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, July 03, 2003 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Change number to character


Hello all,

I am trying to take the OrderRel.OrderNum value and convert it to a string.
When I use this expression: String(OrderNum), I get a get this value:(e.g.
1447.000000). I understand that is the actual value in the OrderNum field
but how would I get it to return just the 1447 without any comma's. I'm not
using the format part. Not sure how I would do it.

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.453.2300







Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=249982.3512844.4795476.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o72ctft/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3512844&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=249982.3512844.4795476.1261774/D=egroupmail/S=:HM/A=1524963/rand=278411206>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Hello all,

I am trying to take the OrderRel.OrderNum value and convert it to a string. When I use this expression: String(OrderNum), I get a get this value:(e.g. 1447.000000). I understand that is the actual value in the OrderNum field but how would I get it to return just the 1447 without any comma's. I'm not using the format part. Not sure how I would do it.

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.453.2300





[Non-text portions of this message have been removed]
3
STRING(OrderRel.OrderNum, ">>>9")

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, July 03, 2003 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Change number to character


Hello all,

I am trying to take the OrderRel.OrderNum value and convert it to a string.
When I use this expression: String(OrderNum), I get a get this value:(e.g.
1447.000000). I understand that is the actual value in the OrderNum field
but how would I get it to return just the 1447 without any comma's. I'm not
using the format part. Not sure how I would do it.

Thanks,

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.453.2300
4
Hello Jasper,

You have to use CStr(OrderRel.OrderNum).

Anna.
--- Jasper Recto <jrecto@...> wrote:
> Hello all,
>
> I am trying to take the OrderRel.OrderNum value and
> convert it to a string. When I use this expression:
> String(OrderNum), I get a get this value:(e.g.
> 1447.000000). I understand that is the actual value
> in the OrderNum field but how would I get it to
> return just the 1447 without any comma's. I'm not
> using the format part. Not sure how I would do it.
>
> Thanks,
>
> Jasper Recto
> Director of Information Technology
> Loc Performance Products, Inc.
> 734.453.2300
>
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com