German,

G> (fieldname: varchar(150), fieldvalue: varchar(150)) =
G> ('comerce num', '90')
G> ('address', 'Yellow Street')
G> ('foundationDate', '01/01/2001')
G> ('comerce num', '200')
G> ('address', 'Black Street')
G> ('foundationDate', '01/01/2000')
G> ('comerce num', '3000)
G> ('address', 'Green Street')
G> ('foundationDate', '01/01/2002')

where do you put the information about which datatype each field is?
I would put it in a column of the same table and filter integer rows
accordingly. Then the type cast would work.
Ciao
--
Nando mailto:nandod@...