delphi sql中加like 写法

'FROM (SELECT hetongbianhao, zhiwu, xingming, shigongfenlei,'+
                          'SUM(shuliang) 设备数量, SUM(yingtichenge) 应提成额 '+
                          'FROM Y_shigongpaigong where zhiwu=''监理'' AND xingming like ''%''+'''+Trim(ComboBox_xingming.Text)+'''+''%''    '+

posted on 2016-07-05 17:07  那里的天空  阅读(528)  评论(0编辑  收藏  举报

导航