Re: SQL HELP

From: Abel_Johnson@doh.state.fl.us > >Using Informix V7.1 SQL, I am trying to concatenate several fields without >leaving any imbedded blanks. Here is a clip of my code. > >insert into forsamis > (confidentialcode, agencycasecode, datecaseopened, involvement > , householdincome, referredfrom, dateofbirth, zipcode > , gender, race, education, closingdate, closingreason) > select hipr.last_name||first_name[1,1]||middle_name[1,1]||birthdate > , case_number, entry_date, child_adult > , household_income, referral_from, birthdate, zip_code > , sex, race, educ_status > , hfpr.terminate_date, hfpr.terminate_reason > from hipr, hfpr > where case_number = case_no > and entry_date >= '07/01/1999';> >The 4th line concatenates into the first variable but, the field >hipr.last_name has trailing blanks which I can not seem to eliminate. What >is the systax. TRIM? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com