Re: SPL problems

Posted in 2001

Tsutomu Ogiwara — Fri, 12 Jan 2001 09:44:47 +0900 — source: Informix-list mailing list archive (1991-1998)

At 10:54 01/01/11 +0000, Stuart wrote: Hi Stuart. How about this ? Define cBatchno char. select to_char(Batchno) into cBatchno from table Regards. >I have defined iBatchno INTEGER and strBatch CHAR(6) variables >I can SELECT INTO iBatchno FROM table > >Now i need to make a string of format : "ABC" || iBatchno > >I can not CAST(iBatchno AS CHAR(6)) >I also can not LET strBatch = "ABC" || iBatchno > >How do I cast an INT to a CHAR, and how do I concat 2 strings into a >varaible? > > -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion Dept CTC, ITOCHU Techno-Science Corporation Yasukuni Kudan-Minami Bldg., 2-3-14, Kudan-Minami Chiyoda-Ku TOKYO, 102-0074 JAPAN Phone:+81-3-5212-4891 Fax:+81-3-5212-4889 E-mail:Tsutomu.Ogiwara@ctc-g.co.jp / tsutoo@my-deja.com