Trim function in V7.1

Posted in 1995

kmart!jregep@uunet.uu.net — 5 Jun 1995 09:08:04 -0400 — source: Informix-list mailing list archive (1991-1998)

Jim Gordon writes: >Is there any function or combination of functions in V7.1 SQl that will take a >character string and if it is full of spaces convert it to NULL as part of an >insert statement? Does it have to be a part of an insert statement? Because this works just fine in 4GL (4.10): if (a_char = " ") then let a_char = NULL end if HTH -- || ======= **** **T* ======= ||John Regep || **** **** ||Kmart Information Systems || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver C-1 || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep