Re: Trim function in V7.1

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!