Re: Help!!! Format Mask in Report 2.5

From: Mabel Trigüis <mabelle_at_bluewin.ch>
Date: 1998/01/16
Message-ID: <01bd22f1$16540630$fc0bbac3@m3bj1>#1/1

I think there is no way to format characters in reports 2.5. You have to format your field manually. Example:
Select substr(social_security,1,3)||'-'||

          substr(social_security,4,2)||'-'||
          substr(social_security,6,42) social_security

from mytable;  

Mabel

hnguyen_at_os.dhhs.gov wrote in article <884960752.960692235_at_dejanews.com>...
> Hi all,
>
> I have a stupid question about Format Mask for a
> field in report 2.5. I have a field Social Security
> in my table. The data type is VARCHAR2(9). I want to
> display the data that looks like 111-22-3333 in my
> report instead of 111223333. Please help me to solve
> this problem.
>
> My email is hnguyen_at_os.dhhs.gov
>
> Thanks in advance.
>
> Hiep Nguyen
>
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Fri Jan 16 1998 - 00:00:00 CST