On Sun, May 02, 2004 at 01:59:34PM -0500, Puneet Kishor wrote: > >Probably you mean the concatenate operator, which in > >SQL is ||, not &. & is not an SQL operator as far as
> drats... concat is '+' in Javascript, '.' in Perl, '&' in Access and > SQL Server, '||' in SQlite, and, well, 'CONCAT' in Oracle. Why can't > the entire world just speak Hindi ;-). It is '||' in Oracle, and I believe PostgreSQL as well. 'CONCAT' may also work there, but if so I've never seen it used. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]