Dear Experts,
I have a Sybase table with a blank space inside its name. How can I
access data from such a table?
Regards,
Serguei.

On Mar 25, 8:57*pm, Serguei.Goumeni... (AT) cibc (DOT) ca wrote:
looks like the table was created after setting quoted_identifier on.
You can access table using

set quoted_identifier on
go
select * from "table x"
go

-HTH
Manish Negandhi
[TeamSybase]

On Mar 25, 6:27*pm, Manish Negandhi <negandhi.man... (AT) gmail (DOT) com> wrote:
OR use square brackets

select * from [table x]

On Mar 26, 1:46 am, PDreyer <petrus.dre... (AT) gmail (DOT) com> wrote:

On Mar 26, 1:46 am, PDreyer <petrus.dre... (AT) gmail (DOT) com> wrote:
For what it's worth, the following is my favorite solution:

1> set quoted_identifier on
2> go
1> sp_rename "table x",table_x
2> go
Object name has been changed.
(return status = 0)
1> set quoted_identifier off
2> go

So there.

\;-)

On Mar 25, 12:27*pm, Manish Negandhi <negandhi.man... (AT) gmail (DOT) com>
wrote:
Hi,
Both solutions (set quoted_identifier on AND use of square brackets)
work with Sybase 12.5, but for Sybase 12.0 they do not work.
1. Have you any idea why it does not work with 12.0?
2. Is there any solution I can use at 12.0?
Regards,
Serguei.

On Mar 31, 7:44*pm, Serguei.Goumeni... (AT) cibc (DOT) ca wrote:

set quoted_identifier on
works for me on 12.0