ReportWriter and phone#/SS#

From: mike sullivan <sullivan_at_sytex.com>
Date: Thu, 18 Nov 1993 22:30:20 GMT
Message-ID: <01e9cc1w165w_at_sytex.com>


Environment: SQL*ReportWriter 1.1.14

             DBMS 6.0.36, Form 3.0.16
          O/S ISC Unix 3.0

Is there any way for ReportWriter to print a phone number in the format xxx-xxx-xxxx (with the -'s)? I can store a phone # as a NUMBER, or a CHAR (I've got it as a CHAR now), but it looks like ReportWriter will not print it out in the desired format (same for social security #). Anyone get around storing the phone # as 3 different fields?

---
sullivan_at_sytex.com (mike sullivan)
Access <=> Internet BBS, a public access internet site
Sytex Communications, Arlington VA, 1-703-528-4380
Received on Thu Nov 18 1993 - 23:30:20 CET

Original text of this message