I have 2 databases DB1 and DB2 and each has a table called TAB1

The problem is that only one of the databases returns 'ABC' twice, the other only returns results back from the first select!


SELECT * FROM TAB1 WHERE FIELD_NAME = 'ABC'
GO
SELECT * FROM TAB1 WHERE FIELD_NAME LIKE 'ABC'

Is there an database option I need to change?

James