用一个循环来判断了: var i: Integer; s, ResultS: string; begin s := 'abcde<hjkl'; Results := ''; for i := 1 to Length(s) do begin if s[i] <> '<' then ResultS := ResultS + s[i] else break; end; end; -------------------------- 上面的应该可以,我没在D里面测试. 但应该没问题. 至少思路这样是可以的.
用 select A from A1 where A like '%<' 再把最后那个'<'东东去掉不就可以了吗?
SELECT LEFT(A, CHARINDEX('<', A) - 1) FROM Table
select SUBSTRING(子段A,1,CHARINDEX('<',A)-1) as XXX FROM YourTable
var
i: Integer;
s, ResultS: string;
begin
s := 'abcde<hjkl';
Results := '';
for i := 1 to Length(s) do
begin
if s[i] <> '<' then
ResultS := ResultS + s[i]
else break;
end;
end;
--------------------------
上面的应该可以,我没在D里面测试. 但应该没问题. 至少思路这样是可以的.
select A from A1 where A like '%<'
再把最后那个'<'东东去掉不就可以了吗?