Re: SILLY SQL QUESTION

Posted in 1995

Benjamin Taub — 4 Apr 1995 03:08:16 GMT — source: Informix-list mailing list archive (1991-1998)

>>I know this sounds daft but is it possible to cat 2 strings together as part of an SQL statement?<< In Informix try double pipe (||) as in: select fname||lname, sum(sales)... MS Access and Oracle also accept the ampersand (&) to do this. -- Benjamin Taub Dataspace Incorporated, Ann Arbor, MI, USA PH: (313) 761-5962 FAX: (313) 761-5967