yes. that did the trick. thank u.

-----Ursprungligt meddelande-----
Från: Calin Iancu Pirtea [mailto:pcalin@...]
Skickat: sö 2003-09-14 15:16
Till: firebird-support@yahoogroups.com
Kopia:
Ämne: Re: [firebird-support] Union

----- 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@...


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Upgrade to 128-Bit SSL Security!
http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/67folB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



ect ing



[Non-text portions of this message have been removed]