Grid question ****SOLVED****

Howdy Folks,

Here's the situation. I'm using an MSHFlexgrid to display some data from an Oracle DB. There's one column which only contains a 1 or a 0. But that's not what I want to see I want to see a Yes instead of a 1 and No instead of a 0.

Anyone knows how to change this withou changing the DB?


WiseGuy

p.s. I've asked this question before but didn't get a clear answer then.

See if Oracle has IIF or similar function.

If so, just put something like :

IIF([tablename].[fieldname]=0,"No","Yes") As NewFieldname in the sql statement.


Vince

Well, I've found another SQL command that fits with Oracle, the other one was for Acces right?

Here's what I use now:

(Decode(Blokkeren,0,'Nee','Ja')) Blokkeren

Thanks for the help,

WiseGuy