include a function in your SQL?

SELECT IIF(strcomp(Field,'n',0),'L','U') AS 'Field', Value
FROM MYTABLE

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Green Chameleon wrote in


I have data being returned from a SQL view via ODBC (IDS on SuSE)
where a specific field has a value of N and n.

The problem is; only N is showing and all n's are summed in...

How can this be solved?

(O/s = Xp & Office = 2K)