我在TQuery中直接將sql語法寫入，如下： select * from TEST where ( (T_NO like '% :tno %') or (:tno is null) or (:tno = '') ) 資料庫是Oracle..，將變數tno給值時就出現錯誤，無法Open..

Hi pig,    改成以下寫法試試

select * 
from   TEST
where  ((T_NO like '%' || :tno || '%') or (:tno is null) or (:tno = '') )

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman