回复：MS Access question

来源: f64 于 2003-11-02 19:48:00 [] [旧帖] [给我悄悄话] 阅读数 : 0 (447 bytes)
本帖于 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

请您先登陆，再发跟帖！