>CREATE TABLE #mytable (f1 char(2) ) >INSERT INTO #mytable VALUES ('A ') >SELECT * FROM #mytable WHERE f1='A' && <-- return empty rowset >DROP TABLE #mytable >>
set ANSI_DEFAULTS ON CREATE TABLE #mytable (f1 char(2) ) INSERT INTO #mytable VALUES ('A ') SELECT * FROM #mytable WHERE f1='A' DROP TABLE #mytable go set ANSI_DEFAULTS OFF CREATE TABLE #mytable (f1 char(2) ) INSERT INTO #mytable VALUES ('A ') SELECT * FROM #mytable WHERE f1='A' DROP TABLE #mytableAnd here is the result:
(1 row(s) affected) f1 ---- A (1 row(s) affected) (1 row(s) affected) f1 ---- A (1 row(s) affected)Thanks,