Remove Leading Zeroes

They want me to remove the 0's (Zeroes) in fron of the test ratings on teachers.

No teacher can be 1.000. The Field is defined as Single.

Here is the Code.

<Table Border=3 Frame=All CellPadding=5 CellSpacing=2 Cols=8>

<TR><TD>City</TD><TD>School</TD><TD>F/L</TD><TD>Educator</TD><TD>#</TD><TD>NM Rate</TD><TD>TX Rate</TD><TD> Hgt </TD></Tr>

<TD NoWrap><%Response.Write rsTeachers("Brtg")%></TD>

How do I remove the leading 0 in the Brtg Field.

They appear as 0.993, 0.995, 0.996, 0.999, etc.

I need them to appear as .993, .995, .996, .999 or
993, 995, 996 or 999 will do.

Thank You for Your Help in Advance

Bill Barber

McKirahan
Sun Jun 20 21:28:49 CDT 2004

"Bill Barber" <BillBarber@discussions.microsoft.com> wrote in message
news:B412E1B6-072E-43AF-AE4C-DA6ADA185A6D@microsoft.com...
> They want me to remove the 0's (Zeroes) in fron of the test ratings on
teachers.
>
> No teacher can be 1.000. The Field is defined as Single.
>
> Here is the Code.
>
> <Table Border=3 Frame=All CellPadding=5 CellSpacing=2 Cols=8>
>
>
<TR><TD>City</TD><TD>School</TD><TD>F/L</TD><TD>Educator</TD><TD>#</TD><TD>N
M Rate</TD><TD>TX Rate</TD><TD> Hgt </TD></Tr>
>
> <TD NoWrap><%Response.Write rsTeachers("Brtg")%></TD>
>
> How do I remove the leading 0 in the Brtg Field.
>
> They appear as 0.993, 0.995, 0.996, 0.999, etc.
>
> I need them to appear as .993, .995, .996, .999 or
> 993, 995, 996 or 999 will do.
>
> Thank You for Your Help in Advance
>
> Bill Barber


if Left(num,2) = "0." Then num = Mid(num,3)

Bob
Mon Jun 21 05:39:49 CDT 2004

Bill Barber wrote:
> They want me to remove the 0's (Zeroes) in fron of the test ratings
> on teachers.
>
> No teacher can be 1.000. The Field is defined as Single.
>
> Here is the Code.
>
> <Table Border=3 Frame=All CellPadding=5 CellSpacing=2 Cols=8>
>
>
<TR><TD>City</TD><TD>School</TD><TD>F/L</TD><TD>Educator</TD><TD>#</TD><TD>N
M
> Rate</TD><TD>TX Rate</TD><TD> Hgt </TD></Tr>
>
> <TD NoWrap><%Response.Write rsTeachers("Brtg")%></TD>
>
> How do I remove the leading 0 in the Brtg Field.
>
> They appear as 0.993, 0.995, 0.996, 0.999, etc.
>
> I need them to appear as .993, .995, .996, .999 or
> 993, 995, 996 or 999 will do.
>
Use the FormatNumber function:
<TD NoWrap>
<%= FormatNumber(rsTeachers("Brtg"),3,false)%>
</TD>

HTH,
Bob Barrows
PS. The vbscript documentation can be downloaded from here:
http://tinyurl.com/7rk6

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"