I have a column that looks like this

Open

NULL

R252

R253

NULL

or

Openid open

r252 abc

...

Some rows are returning NULL and I don't need

the rows with NULL to be returned.

This is how it looks like.

Open

NULL

R252

R253

NULL

Homebrew

I tried Open > " and it turn to Open > '""'. But it did not work

I am still getting null value

my query is simple

select open from view_rpt

where open is...

Thanks doug, that is what microsoft connect guys also told me. Unfortunately I can't convince this people here to upgrade their server to 08.

Can you please be more specific, do you mean Solution "Appeal report" Property Pages

under configuration property. I can't find where you make that choice.

the only namespace I know is when...

Thank you all for your help

Ok thanks a lot for your advice you are my hero

Thanks all for your cordial advice i will be even willing to work 2 weeks for free