Hi Alan,

you use SQL Server ?

If yes, you read on BOL:

The COLLATE clause can be applied only for the char, varchar, text, nchar, nvarchar, and ntext data types.

This is not a arbitrary restriction because COLLATE have sense only for text info.

On my example i want _TALLY return 1 because i want exact binary matching.

Fabio