>Is it possible to do an IIF in a column to display a char value like 'n/a' if the value is 0?
>I have a column based on a cursor and the data is numeric. If the value is 0 I want to display 'n/a'...
I don't think so. You can however use char and convert the numeric to char with a str() function.
i.e. SELECT IIF(myfield>0,STR(myfield,X,X),"N/A") as myfield... etc...
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!