----- Original Message -----
From: "Datatal AB - Gauffin, Jonas"

>your suggestion doesnt work :(
It should work, it's just a little misspelled.


>> Try this:

>> SELECT ('förste kapten' AS VARCHAR(15)), fornamn, efternamn ...

>> UNION

>> SELECT (CAST 'andre kapten' AS VARCHAR(15)), fornamn, efternamn ...

>> UNION

>> SELECT (CAST 'vardinna' AS VARCHAR(15)), fornamn, efternamn ...

Should be like this:

SELECT ... CAST('vardinna' AS VARCHAR(15)) as COLUMN_NAME, ...

Try it.

Ciao,



Best regards,
Application Developer
Calin Iancu, Pirtea
S.C. SoftScape S.R.L.
pcalin@...