FYI: The big players seem to have standardized on using a CONCAT function in recent years. Oracle traditionally uses ||. SQL Server traditionally uses +. MySQL doesn't seem to have any alternative.
Paul On Mon, Nov 1, 2021 at 10:34 AM 'Michael Chaney' via NLUG < nlug-talk@googlegroups.com> wrote: > In fairness, SQL was created in the early 1970s, just a little bit after > the C language. It greatly predates all of the other languages using a > C-based syntax that also use "||" as "logical OR". > > On Mon, Nov 1, 2021 at 8:09 AM Tilghman Lesher <tilgh...@meg.abyt.es> > wrote: > >> I think he missed the worst possible string concatenation operator, >> from SQL: ||, worst because it means logical OR in pretty much every >> other language out there. If you want to make people fail, reusing >> operators in a completely different and mutually incompatible context, >> is clearly the way to go. >> >> On Sun, Oct 31, 2021 at 12:40 PM Howard White <hwh...@vcch.com> wrote: >> > >> > Enjoy... >> > >> > <https://www.youtube.com/watch?v=2mnYf7L7Amw> >> > >> > Howard >> > >> > -- >> > -- >> > You received this message because you are subscribed to the Google >> Groups "NLUG" group. >> > To post to this group, send email to nlug-talk@googlegroups.com >> > To unsubscribe from this group, send email to >> nlug-talk+unsubscr...@googlegroups.com >> > For more options, visit this group at >> http://groups.google.com/group/nlug-talk?hl=en >> > >> > --- >> > You received this message because you are subscribed to the Google >> Groups "NLUG" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to nlug-talk+unsubscr...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/nlug-talk/96d1be14-8f91-0a40-5d97-1acde6be01aa%40vcch.com >> . >> >> >> >> -- >> Tilghman >> >> -- >> -- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To post to this group, send email to nlug-talk@googlegroups.com >> To unsubscribe from this group, send email to >> nlug-talk+unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/nlug-talk?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to nlug-talk+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/nlug-talk/CAHPkZcUxh6JJVHqko%2Bup3RaDDSJmvX%3DMs%3D3Z80Vnhotdrq63mw%40mail.gmail.com >> . >> > > > -- > Michael Darrin Chaney, Sr. > mdcha...@michaelchaney.com > http://www.michaelchaney.com/ > > -- > -- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to nlug-talk@googlegroups.com > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to nlug-talk+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/nlug-talk/CAAtfUtE5Z8dS2SrcgD%2BtY1MeEk39h6xTe8gbEUikdYF5Of9M8Q%40mail.gmail.com > <https://groups.google.com/d/msgid/nlug-talk/CAAtfUtE5Z8dS2SrcgD%2BtY1MeEk39h6xTe8gbEUikdYF5Of9M8Q%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-talk@googlegroups.com To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to nlug-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nlug-talk/CAL9PgS0yYCR_rv4WhPJV6HSFdRc6_v38HgUq4_H%2BGHKk7%3DC6uA%40mail.gmail.com.