On 01/05/2007 15:38, novnov wrote:
I didn't express myself clearly. Is there an IIF type function one can use
inline in a view?
SELECT UserName, IIF(mybooleanfield = true, "It's true", "It's not true") as
SayIt FROM tblUser
That's what CASE is for:
select
case
when mybooleanfield then 'It''s true'
else 'It''s not true'
end as SayIt
from
tblUser;
(...or something like that - look it up in the docs).
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
