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' :)

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!

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.