Member Avatar for fisk007

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 because: n/a
  • 2 Contributors
  • 2 Replies
  • 1K Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by fisk007
Member Avatar for sknake

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!

Member Avatar for fisk007

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.