Replacing Null with 'N/A' for Year Enteries

#1

An easy way would be to update the view when you select
the records from the table.

Thanks
GS

Quote:

-----Original Message-----
Pie ChartsHi All

In my time dimension(Year,Quarter,Month) field
(Iam using views not any fact or dimension tables), due

to some of the date values are null i am getting year
values like 0,2001,2002.How to remove this 0 and Replace
it with 'N/A' from my year values?

Quote:

How i can replace the 0 year with 'N/A' ?

Thanks
Vasu

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap