on*******@firstdbasource.com wrote:
While the concat function is great, if you ever want to move this to a
real database engine like oracle... you can/should the ANSI standard
syntax.
select field1||','||field2||','||field3.... from tablex where ....
It should be mentioned that one has to set the SQL_MODE of
PIPES_AS_CONCAT or ANSI to enable this syntax.
Using this syntax without either of those SQL_MODE values in effect is
still a legal expression. The double-pipe works like logical OR when
not running in ANSI mode. So the resulting value of the expression will
be 1, which might be confusing.
Regards,
Bill K.