[SOLVED] Strange result for query field

That didn't change anything.
But removing a user that was manually created (in joomla's user management) added to the group in question, and didn't have any info in it, removed the problem.
I looked up the ID's in the comprofiler table, and it's all NULL's, except the 'approved', 'confirmed' and 'avatarapproved'.

Run synchronization within CB Tools to fix users added through Joomla user manager. You need to always ensure to use CB user management.

The users are synced (I've actually run most of the checks I can find), but it still shows strange results.

Don't know what to tell you. Seams to be working fine in all my tests. There's some sort of odd conflict somewhere. Seams like you've some corrupt users or something of the sort. Maybe try the below.

The above would return a blank if there is no `by`.

Hmm, I had put this away, to get some fresh eyes on it, but it's still not working properly.
I'll start from the top

I have these fields:
name (predefined)
cb_adresse (text)
cb_postnrby (delimiter)
cb_medlemsnummer (integer)
cb_betalt (multiselect)

placed in a list

Users enter a field called cb_postnummer in their profile.
cb_by is then found via a query looking like this:
[cb:if cb_postnummer!=""]SELECT `by` FROM `kef_postnumre` WHERE `nr` = '[cb_postnummer]'[/cb:if]
cb_postnrby is then defined as a delimiter field containing
[cb_postnummer] [cb_by]

I tried both the 'if' construction and the select construction, the if produced the city, but didn't solve the problem, the select didn't produce the city (as shown below).
Notice that for the person that doesn't have a city given, the two fields are empty (as they should be), but on the next line the 'tag-replacement' in the delimiter field fails. Maybe the problem lies in the delimiter field instead?

Just tried something stupid, I set the two fields cb_postnummer and cb_by to show on the profile, that is normally only shown on the 'edit profile' as I can't show them after one another on one line unless it's a delimiter field.
So I only have the delimiter field showing on the profile.
So for this test I have them shown on the profile, and now it displays correctly in the list as well!!
This is not a solution, as I don't want the two fields to be shown seperately, but it does point to the delimiter being the problems.