Question

1. In SQL, what is the difference between the Concat function and the Concat_WS function?

Answer 1

Answer-

Difference b/w the Concat function and the Concat_WS function-

• Fundamentally, both the parts are exploited to add more than two strings.

Concat function-

• CONCAT() is no make of the separator and it returns NULL if some argument is NULL

Select CONCAT('The','House') AS 'result';
Result:

• TheHouse

Concat_WS function-

• CONCAT_WS() can do the joining along with a extractor b/w strings and its returns NULL if the separator is NULL.

Select CONCAT_WS(' ','The','House') AS 'result':
Result:

• The House

Note- Please do upvote, if any problem then comment in box sure I will help.