Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jim Gordon — — source: Informix-list mailing list archive (1991-1998)
On Jun 5, 8:30am, kmart!jregep@uunet.uu.net wrote:
> Subject: Trim function in V7.1
> 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
|| ======= **** **T* ======= ||John Regep
Unfortunately yes as the insert statement is itself in an SP.
Cheers - Jim
--
-----------------------------------------------------------------------------
Jim Gordon DHL Airways Inc. jgordon@us.dhl.com
-----------------------------------------------------------------------------
My opinions are my own. They may vary with time but they remain mine!
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.