請問BDE 如何下SQL敘述，才能對Table中Text 型態的欄位做關鍵字搜尋 ??

AField ==> Text in Table
小弟原寫 SELECT * from Table_Test where CAST(AField as varchar) like '%Save%' 但是不行 !!



=Tks=

試試:

SELECT * from Table_Test where patindex('%Save%', AField) > 0