![]() If you do so, as you observe the result will be NULL − ![]() In the following example we are passing a NULL value as a separator. SELECT CONCAT_WS(' = ', '#$%jhg*', AS CONCAT_WSFunction The following SELECT query adds two strings that contain symbols − SELECT CONCAT_WS('456', 'Good', 'morning', 'Everyone') AS CONCAT_WSFunction Here, we can also provide numerical values as a separator − On executing the above query, it will produce the following output − SELECT CONCAT_WS(' ', 'HELLO', 'WORLD') AS CONCAT_WSFunction The following Query uses space between two strings − The above SQL query produces the following output − The following SELECT query returns a new string as space by adding more than 2 characters − SELECT CONCAT_WS('_','Tutorialspoint', 'Company') AS CONCAT_WSfunction įollowing is the output of the above query − The following SELECT query adds two characters and creates a new string − The SQL CONCAT_WS() function returns the same string as the operator returns from the same expressions as the operands along with separator.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |