> > Use two pipe symbols.
> >
> > SELECT
> > image_title,
> > 'http://www.hello.com/empower/global/' || filename AS image_location
> >
> Uuuuuuuggggggggggggghhhhhhhhhhhhhhhhh!!!!!!!
>
> Why would they select the Bit OR operator? Let me guess this only works
> for Oracle and not any other database.
Believe it or not Duane, since you ask, || is the standard SQL
operator for string concatenation as defined by the ANSI standard.
I think IBM DB2, PostgreSQL, Informix and Sybase SQL Anywhere
support it as well as Oracle.
But...
Sybase SQL Server, M$ SQL Server and Access use +
MySQL and Ingres have a concat() function.
Pervasive.SQL has three subtly different string concatenation
operators: * , + and ++
So much for standards then...
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
