select * from newpartlotlist where lotid='A680102.3'为什么没有结果?

[static504]

SQL> select lotid from newpartlotlist;

LOTID
-----------------
A680113.1
A680110.1
A660241.6
A999722.2
A660465.1
A899704.1
A680125.1
A660280.1
A660460.2
A680101.1
A999719.1
A680102.3
ZTEST9073.1
ZTEST9073.2
ZTEST9075.2
ZTEST9077.1
ZTEST9096.3
ZTEST9999.1

18 rows selected.

SQL> select * from newpartlotlist where lotid='A680102.3';

no rows selected

[BenZ004]

是的，同意上面两位

[szpqq]

up

[dongnaixin]

或者select * from newpartlotlist where replace(lotid,' ','')='A680102.3';

[dongnaixin]

我估计你的字段类型是char型，应该是空白符问题

[jxc]

试试
select * from newpartlotlist where trim(lotid)='A680102.3';

[yang2004]

同意樓上的. 估計內容中空白符存在.

[dlmaomao]

建议你用varchar2类型，可以避免空白符问题