> > 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...
Thanks for the clarification Nick. Some much for standards :(
Duane
------------------------------------------------------------------------------
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.
