Ask Your Question

Revision history [back]

An empty text field is stored as null which prevents concatenation from working. if the only field that may be empty is voorvoegsel then the solution provided by @Ratslinger is fine but if other fields can be empty then the case statement will become very long.

An alternative is to set the default value for any of the fields that can be empty to space in the Table. These fields will then never be null and the SQL you are using will work.

An empty text field is stored as null which prevents concatenation from working. if If the only field that may be empty is voorvoegsel then the solution provided by @Ratslinger is fine fine, but if other fields can be empty then the case statement will become very long.

An alternative is to set the default value for any of the fields that can be empty to space in the Table. These fields will then never be null and the SQL you are using will work.