Re: Query a column name which has a space in it.

Try select 'part number' from xyz where 'part number' = ......

The key is to use quotes around the field name...

Abeeda_Mohammed_at_xn.xerox.com wrote:

>If I create a view as
>
>create view xyz as select part_no "part number"
>from
>part_master;
>
>Now the description of the view XYZ is
>
>PART NUMBER
>
>how do I
>write the query to search a particular part_no from this view?
>
>
>Thank you,
>
>Abeeda Mohammed
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 04 1998 - 16:05:57 CDT