add Field and assign him Data type

[Anon]

Hi!

I'm beginer in programing in ISQL so i'm having some troubles with a assignig a Data type to field...

I made a View off two VIEWs and i vhant to add new field where the value will bi aways null, code look's like this:

select ONE1, THREE1, '' AS THREE2, FOUR1 from VIEW1
union
select ONE2, '' AS THREE1, TREE2, FOUR2 from VIEW2

Field THREE1 and THREE2 is type of FLOAT.
And problem is that becaus of statement:

'' AS THREE1 and '' AS THREE2 whenn I try to compile it, it notifys me with this statment:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
Data type unknown.

I understand that is wrong Data type but i whant to know how can i assign data type to the value that i'm assignig to field THREE1 and THREE2?

Thank's!
Sekec

Ps.: I'm sorry for my english, it's not to good...