sql里当然没有这个函数了,改成 s1:='select * from person where '+trimleft(birthday,4)+'<1975';好像不用 这样应该得 s1:='select * from person where trimleft(birthday,4)<1975';
这个是操作Access的库的: sl := 'select * from person where CInt(Left(birthday,4)) < 1975'; SQLServer的应该是: sl := 'select * from person where StrToValue(Left(birthday, 4)) < 1975';
Access int(trimleft(birthday,4))
s1:='select * from person where '+trimleft(birthday,4)+'<1975';好像不用
这样应该得
s1:='select * from person where trimleft(birthday,4)<1975';
sl := 'select * from person where CInt(Left(birthday,4)) < 1975';
SQLServer的应该是:
sl := 'select * from person where StrToValue(Left(birthday, 4)) < 1975';