I have a sql statement where

CONCAT_WS(' ',p.projektnr,vedr) AS text

is a part of the statement. My problem is, that it returns a BLOB.

'p.projektnr' is af numeric field and in a lot of cases it is negative. If i change the 'p.projektnr' with eg. another text field the statement returns a string like it have to.

How can i make a concat with a number and a text field and get it to return a string?