Used db: mariadb; OS: Windows10 & Xubuntu18.04; LO: 6.3.x
I made a sql query with the following suntax:
SELECT CONCAT(`SurName`, ', ', `FirstName`) AS `FullName`, `MemberID` FROM `Members`
The result is a table with two columns:
In de field
Fullname I got the name with the syntax:
Johnson, Boris or
But if the field of the
FirstName is empty the field with Fullname is empty. If I have f.e. a
space in the field
FirstName I will see f.e.
How can I make the SQL Query in this way that I don’t need to fill in everywhere a
space in a field?