各位先進高手大家好: 小弟在維護前人留下的程式, 裡面有一個欄位名稱 A-B ,  要如何下SQL才能選出此欄位的資料.    Select A-B from Table1 <-- 錯, 他會認為是減 Select "A-B" from Table1 <-- 錯 資料回來都是文字"A-B" 該如下指令~~~~感謝賜教~~~ 我不是高手, 高手是正在銀幕前微笑的人.

------


我不是高手, 高手是正在銀幕前微笑的人.

How about: select 'A-B' from Table1 select [A-B] from Table1

引言: How about: select 'A-B' from Table1 select [A-B] from Table1

Hello william 先進您好: I had tried it. But still can't work. 1. 'A-B' same with "A-B" 2. [A-B] cause worng message. 我不是高手, 高手是正在銀幕前微笑的人.

I have tried tha character 'A-B', "A-B", [A-B], `A-B` in SQL Explorer and all work properly... What is the error message?

引言: 各位先進高手大家好: 小弟在維護前人留下的程式, 裡面有一個欄位名稱 A-B , 要如何下SQL才能選出此欄位的資料. Select A-B from Table1 <-- 錯, 他會認為是減 Select "A-B" from Table1 <-- 錯 資料回來都是文字"A-B" 該如下指令~~~~感謝賜教~~~ 我不是高手, 高手是正在銀幕前微笑的人.

SELECT DISTINCT "TEST.db"."A-B" FROM "TEST.db" ORDER BY "TEST.db"."A-B"

引言: I have tried tha character 'A-B', "A-B", [A-B], `A-B` in SQL Explorer and all work properly... What is the error message?

Hello william sir : Use "A-B" data will all return "A-B". Use [A-B] return "Invalid use of keyword Token:[A-B]" But I used P.D sir's example were successfully. 感謝兩位先進的幫忙~~~~~ 我不是高手, 高手是正在銀幕前微笑的人.