回複:MS Access question

本帖於 2004-02-06 15:24:48 時間, 由普通用戶 old-cotton 編輯

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

請您先登陸,再發跟帖!