Re: SUBSTRING FUNCTION IN FORMS 3.0

In article <1992Aug13.081954.279_at_falcon.navsses.navy.mil>, mdipilla_at_falcon.navsses.navy.mil writes:
|> TO WHOMOVER KNOWS WHATEVER,
|>
|> WOULD ANYONE KNOW IF THERE IS A SUBSTRING FUNCTION IN FORMS.
|> WE BASICALLY HAVE A FIELD WHICH THE USER WOULD INPUT. HE WILL BE
|> TYPING IN A "-" SOMEWHERE IN HIS FIELD. IT CAN BE IN THE THIRD POSITION
|> XX-XXXX OR IT CAN BE IN THE FOURTH POSITION XXX-XXXX. HOW CAN I REMOVE
|> THIS HYPHEN.
|>
|> THANK YOUR VERY MUCH
There is one.

  Page 4-18 in the SQL Language Reference Manual Version 6.0

     SUBSTR(char,m,n)

  Example: SELECT SUBSTR('ABCDEFG',2,3) "Sugstring" FROM DUAL

  Returns: BCD

J. Mark Toms                                email: mtoms_at_ems.cdc.com
Baltimore Gas & Electric, Company
C/O Empros Systems International            Phone: (612) 553-4423
2300 Berkshire Lane North                     FAX: (612) 553-4018
Plymouth, Minnesota  55441-3694 USA      Mailstop: PLY060
==========================================================================