LIKE is a string function, and binary values are converted to
the type of the column you are comparing against. If it is Unicode,
you may need LIKE 0x2500530054002500, and if it is fixed-length
instead of nvarchar, the conversion will padd the binary string with
spaces if necessary.
Michael Tissington wrote: