Re: Computed columns
Posted in 1995
Tony Tyrwhitt-Drake — — source: Informix-list mailing list archive (1991-1998)
In article <kcjDF8HBo.ru@netcom.com>, kcj@netcom.com (Kate Juliff) says: > > > I need to concatenate two numbers so first have to convert them to text. Is there a convert to >text function. > A simple way to concatenate two numbers is by the multiply and add strategy for example; say you want to concatenate two 2 digit numbers. Multiply the left number by 100 ( 10 to the power of the length of the right number ) and add the right number left number 99 right number 88 99 x 100 = 9900 + 88 = 9988 .....or is this too obvious :->