MemSQL UDF to check if sql_mode = PIPES_AS_CONCAT. Returns TRUE if sql_mode contains PIPES_AS_CONCAT, else FALSE.

Changes all use of '||' in stored procs to the concat function. It was more of a challange than I originally thought, but I got it done in less time than updating and testing all the several thousand ...

While writing queries in stored procedures we manipulate with the string data type columns in which concatenating string is very common. So we all are very familiar with the function CONCAT provided ...