Hi Leo,

I believe what you're seeing are broken lookups. This means those values, like B710-A, are not present in the target of that lookup. That is why LabKey appended brackets (<>) around the values.

When this happens, LabKey renders the value as a string, but treats the raw value as NULL. This is probably why they are sorting as you're seeing. The behavior is a little funny, but it has roots in the fact it's very common for a lookup to have a different raw value and display value, and these columns frequently have different datatypes.

If you add the problem records to your lookup table, it should sort as you'd expect.