G
Guest
I cannot select a column if it has a space.
------------------------------------------------------------------------------------------
For example, i have a table:
Short name Code Year_Produced
ABA 1001 2005
BBB 1544 2001
CCC 1002 2000
------------------------------------------------------------------------------------------
I cannot select "short name" because there's a space in between
While i can select "Year_Produced" , because there's underscore("_") in
between.
------------------------------------------------------------------------------------------
How can I write an SQL to select name with space in between. Using quote ?
How ?
please kindly show me an example !
thank you , expert !!
------------------------------------------------------------------------------------------
For example, i have a table:
Short name Code Year_Produced
ABA 1001 2005
BBB 1544 2001
CCC 1002 2000
------------------------------------------------------------------------------------------
I cannot select "short name" because there's a space in between
While i can select "Year_Produced" , because there's underscore("_") in
between.
------------------------------------------------------------------------------------------
How can I write an SQL to select name with space in between. Using quote ?
How ?
please kindly show me an example !
thank you , expert !!