Re: Computed columns

Posted in 1995

CRAIG@CHEMISTRY.CHEM.UTAH.EDU — 21 Sep 1995 11:43:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Kate, How about: SELECT int_col1 || int_col2 FROM table... Don't worry about the conversion to text, I believe Informix handles it automagically. --Craig (craig@chemistry.utah.edu) > > How do I simulate a computed column in Informix? I need to concatenate > two numbers so first have to convert them to text. Is there a convert to > text function. Is there any way of simulating a computed column? > Thanks in advance, >