原代码如下:
with ADODataSet1 do
begin
Active := False;
CommandText := 'select * from UserInfo where CompanyName like ''6765%%''';
Active := True;
end;查询出来数据为
CompanyName
-----------
6765%
6765%%
6765但是我只想查询6765%这一条记录。
with ADODataSet1 do
begin
Active := False;
CommandText := 'select * from UserInfo where CompanyName like ''6765%%''';
Active := True;
end;查询出来数据为
CompanyName
-----------
6765%
6765%%
6765但是我只想查询6765%这一条记录。
begin
Active := False;
CommandText := 'select CompanyName from UserInfo where CompanyName like ''6765#%%'' escape ''#''';
Active := True;
end;
begin
Active := False;
CommandText := 'select CompanyName from UserInfo where CompanyName
like '6765[%]%';
Active := True;
end;
begin
Active := False;
CommandText := 'select * from UserInfo where CompanyName = 6765%';
Active := True;
end;
begin
Active := False;
CommandText := 'select CompanyName from UserInfo where CompanyName
like '6765[%]%';
//或者
CommandText := 'select CompanyName from UserInfo where CompanyName
like '6765_%'; //_单字符匹配
Active := True;
end;
CHARINDEX('6765%',CompanyName )=1
CommandText := 'select CompanyName from UserInfo where CompanyName like ''6765#%%'' escape ''#'''; CommandText := 'select CompanyName from UserInfo where CompanyName like ''6765[%]%'''; CommandText := 'select CompanyName from UserInfo where CompanyName like ''6765_%''';结贴!!!