""Surojit Niyogi"" <saniyogi@...> wrote in message
news:<000c01c1071f$66d350f0$5bcb27d8@efabtech>...

>
> CREATE VIEW "SUSERCOMPANY" (
> "TITLE",
> "uPhone", <===========>
> "uFax",
>
> If I try to access the uPhone column with the statement "SELECT uPhone

FROM SUSERCOMPANY;", it throws an error -206 (column unknown) It works with
any other column though. I also tried UPHONE thinking it was case sensitive
but that didn't work either.

Please RTFM. Your column is defined as
"uPhone", right?
Then you need
SELECT "uPhone" FROM SUSERCOMPANY;
If this doesn't work, then it's a bug. Otherwise it's misuse. Fields not
enclosed in double quotes are uppercased.

C.