回複：MS Access question

來源: f64 於 2003-11-02 19:48:00 [] [舊帖] [給我悄悄話] 閱讀數 : (447 bytes)
本文內容已被 [ f64 ] 在 2004-02-06 15:24:48 編輯過。如有問題，請報告版主或論壇管理刪除.

1. do not assume your users are all idiot. they can learn to know * stands for everything.
so just use WHERE FullName = [Input here:];
tell your users to put John* in the box.

if you want the second approach, you need "dynamic building of sql string", which is not available in access, only in SQL Server.

2. IIRC, Access does not support *John*. It only allows John* (or maybe *John ?). Only SQL server support the form %John%



--文學城www.wenxuecity.com--

所有跟帖： 

• thanks, but it doesn't work -kf_ying- ♀ 給 kf_ying 發送悄悄話 (345 bytes) () 11/02/2003 postreply 20:50:00

請您先登陸，再發跟帖！