RE: SQL HELP

Posted in 1999

Abel_Johnson@doh.state.fl.us — Tue, 26 Oct 1999 08:26:50 -0400 — source: Informix-list mailing list archive (1991-1998)

Trim it is. Thanks all. My brain is turning to mush...

↪ replying to Abel_Johnson@doh.state.fl.us

Rudy Fernandes — Tue, 26 Oct 1999 11:39:39 -0400 — source: Informix-list mailing list archive (1991-1998)

Just in case it is applicable to your case : If any of the column in the concatenation is NULL, the complete string returned will be set to NULL. For example, in the stmt "select hipr.last_name||first_name[1,1]||middle_name[1,1]||birthdate", if any of last_name, first_name, middle_name or birthdate is null for a row, a NULL will be returned for the row. Rudy Abel_Johnson@doh.state.fl.us wrote: > Trim it is. Thanks all. My brain is turning to mush...