FP 2002 and database results

[Art]

I am stumped.........

I am using FP2002 to query a SQL table and return
results.

That all works fine.

Two of my columns of data in the SQL table are about 50
characters in length actually a hyperlink). Since I have
the values being returned as a link, all I want to display
on the FP table results is the last 10 characters of the
link.

I have tried forcing the column width size, trying
different justifications and even setting the no wrap.

Anyone have any ideas on how to limit the display of the
large field return?

Thanks

 

[MD WebsUnlimited.com]

Hi Art,

You'll need to modify the code produced by the DRW to truncate the link.
--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
Our latest products "At Your Command" and IncludeASP
http://www.websunlimited.com/order/Product/AYC/ayc.htm
http://www.websunlimited.com/order/product/includeASP/includeASP.htm

 

[grw]

<%=Right(FP_Field(fp_rs,"column"),10)%>