Ya know, this makes sense. Though I should never get to a 5 digit number, I've been bit before with assuming things like that. I think it was mentioned earlier to do a LEN() check. I think I want to stay away from changing the BasicType, though. No guessing what can of worms THAT would open.
Thanks everyone for your insights! BobW -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wols Lists Sent: Monday, July 11, 2011 2:31 PM To: [email protected] Subject: Re: [U2] Simple FMT question On 08/07/11 20:17, Bob Woodward wrote: > I know that X = ("0000":X)[4] works to get my results but FMT should > work, too. The major benefit is that if the number is more than 4 > digits, FMT won't truncate it. I hope..... Others have pointed this out too, but ime FMT adds text marks if you go over the specified length. Test it, but FMT(12345, "4'0'R") would give, I think, "1tm2345". That's the syntax I'm used to - UV Prime flavour. Cheers, Wol _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1388 / Virus Database: 1516/3758 - Release Date: 07/11/11 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
