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

Report message to a moderator

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;

Report message to a moderator

Previous Topic: DRAWINGS ON FORMS DEVELOPER
Next Topic: LONG Insertation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 03:12:44 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.