1. Forum
  2. Usenet
  3. COMP.LANG.MUMPS

  • SQL/Control characters

    From Steve@21:1/5 to All on Thu Jan 7 08:31:13 2021
    Need to remove control characters from the output of Cache SQL. Can that be done within SQL? Using $ZSTRIP? Something else?

    Steve

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rod Dorman@21:1/5 to [email protected] on Thu Jan 7 18:53:59 2021
    In article <[email protected]>,
    Steve <[email protected]> wrote:
    Need to remove control characters from the output of Cache SQL. Can that be >done within SQL? Using $ZSTRIP? Something else?

    $ZSTRIP(string,"*C") will remove all the control characters from string

    --
    -- Rod --
    rodd(at)polylogics(dot)com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)