0

Hi
I have a problem where dot is used in a table's column name.

Say that there is a column called 101.name in a table t1.

How do i reference this column in the following:

select ... from table t1, table t2 where t1.101.name='test'

This doesn't work because of the two dots in the same reference.

Does anyone know how to do this?

Thanks

-------------
Looks like it is t1.[101.name]='test' :)

Edited by fisk007: n/a

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by fisk007
0

Was the text below the line what you edited? It looks like you have solved your own problem. You should be able to use [Col.Name Space_Field] to escape any character in a column name.

Please mark this thread as solved since you seemed to have answered your own question and good luck!

0

Was the text below the line what you edited? It looks like you have solved your own problem. You should be able to use [Col.Name Space_Field] to escape any character in a column name.

Please mark this thread as solved since you seemed to have answered your own question and good luck!

Yes, but thank you :) Solved

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.