Peter,
I tried as this:
create table [S&M](num int)
insert into [S&M](num) values(1)
insert into [S&M](num) values(2)
insert into [S&M](num) values(3)
select * from [S&M]
num
-----------
1
2
3
It works.
Did the developer PC applied SQL2K-SP3a? Try it.
"&" has special meaning is Microsoft products, try to avoid it for any object naming. I think that table was from other database upsizing, ex. Access. A quick soluthion to rename the table, or any such tables, to
[T_WContracts],that name is still readable as similar meaning, but less trouble in coding.
Hopefully this ways work for you.
I tried as this:
create table [S&M](num int)
insert into [S&M](num) values(1)
insert into [S&M](num) values(2)
insert into [S&M](num) values(3)
select * from [S&M]
num
-----------
1
2
3
It works.
Did the developer PC applied SQL2K-SP3a? Try it.
"&" has special meaning is Microsoft products, try to avoid it for any object naming. I think that table was from other database upsizing, ex. Access. A quick soluthion to rename the table, or any such tables, to
[T_WContracts],that name is still readable as similar meaning, but less trouble in coding.
Hopefully this ways work for you.