syntax disagreement. SQL as I learned it uses || as concatenate operator

In perl, || is or, && is and.

|| is concatentate in Oracle SQL only.

It's concat in DB2, iSeries SQL/400 as well. In fact, given that the IBM SQL is the benchmark and one of the original players in setting up the conventions, one might say that || = concat is the only correct usage in the SQL world and everyone else is doing it wrong

It's concat in DB2, iSeries SQL/400 as well. In fact, given that the IBM SQL is the benchmark and one of the original players in setting up the conventions, one might say that || = concat is the only correct usage in the SQL world and everyone else is doing it wrong

It's concat in DB2, iSeries SQL/400 as well. In fact, given that the IBM SQL is the benchmark and one of the original players in setting up the conventions, one might say that || = concat is the only correct usage in the SQL world and everyone else is doing it wrong

Doesn't that mean Wife = "BeautifulUnderstandingLove of my life"

You need some spaces and commas in there

geesh your worse than the users. you just gotta have everything perfect..