Home » Developer & Programmer » Forms » FORMAT MASK
FORMAT MASK [message #78345] Fri, 15 February 2002 03:16 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
I KNOW HOW TO DO FORMAT MASK. HOWEVER HOW DO I PUT A FORMAT MASK IN A FIELD WHERE THE DATA TYPE IS CHAR. I WOULD LIKE THE FORMAT MASK TO BE 4 CHARS OF DATA MISS A SPACE AND THEN 3 MORE CHARS OF DATE. EG
V678 980

ANY HELP PLEASE
Re: FORMAT MASK [message #78346 is a reply to message #78345] Fri, 15 February 2002 03:49 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
select substr(ename,1,4)||' '||substr(ename,5) from emp;
Previous Topic: DRAWINGS ON FORMS DEVELOPER
Next Topic: LONG Insertation
Goto Forum:
  


Current Time: Sun Mar 29 23:41:11 CDT 2020