How to get required space between field names

M$:
SELECT contactid AS [Contact Id] FROM tContacts;

PostGRE:
SELECT contactid AS "Contact Id" FROM tContacts;

shreedhar wrote:

On Tuesday 20 May 2003 08:31, shreedhar wrote:

Hi All,

How to get required space between field names.

example.
field name is : contactid
But I would like to display it as 'Contact Id' in my report.

If I write query like in SQLServer 2000 I am getting an error.

* SELECT contactid AS [Contact Id] FROM tContacts;

How about:
SELECT contactid AS "Contact Id" FROM "tContacts";

Be very careful with mixing upper and lower cases in object names.
If Your table name is upper or mixed case You must quote it too, as shown
in example.

How can I get similar to above operation.

Thanks & Regards,
Sreedhar Bhaskararaju

Our greatest happiness in life does not depend on the condition of life in
which chance has placed us, but is always the result of good conscience,
good health, occupation, and freedom in all just pursuits

Regards !

On Tue, 20 May 2003, Darko Prenosil wrote:

SELECT contactid AS "Contact Id" FROM "tContacts";

Be very careful with mixing upper and lower cases in object names.
If Your table name is upper or mixed case You must quote it too, as shown
in example.

It's amazing how many of us failed to think about the table name in that
question.

--
Nigel Andrews