[SPAM] - Removing Leading Zeroes - Sender is forged (SPF Fail)

[Pickering, John (NORBORD)]

But the original request asked how to do this if the starting string
wasn't entirely numeric - e.g. "000123ABC".

 

________________________________

From: powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com] On
Behalf Of Clifford Zivi
Sent: Wednesday, May 07, 2008 3:46 PM
To: powerh-l at lists.sowder.com
Subject: [SPAM] - Removing Leading Zeroes - Sender is forged (SPF Fail)

 

Hello,  I just joined this list and can't figure out how to answer a
post yet, but I figured I could give you a more elegant solution to the
Removing Leading Zeros posting.  All you have to do is NCONVERT() to
convert it to a string, then if you need it to be a string again, just
use ASCII() to convert it back; the leading zeros will be dropped.

 

Thank you,

 

Clifford Zivi

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080507/055cf326/attachment.html