Hi again,

Solved it myself, sort of ...

Adding "Collate SQL_Latin1_General_CP437_CI_AS" to the query solved the problem.

I.e. "... MyColumn Collate SQL_Latin1_General_CP437_CI_AI Like '123456A%'" returns the expected rows.

It also works when specifying the...

Perhaps I should add, that the query is into a view, not a table.

And that the database in question has a default collation named "Danish_Norwegian_CI_AS".

I don't know whether this makes...