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]>

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to