Find specific byte combination inside NVARCHAR

Question

We found out that we have a bunch of french strings with incorrect characters. We know that the hexadecimal representation of the character is 0xFDFF. Is there an easy way to SELECT the rows in a table where the NVarchar field contain this character?

Thanks

Answer 1

WRONG: select * from YourTable where YourCol like '%' + CONVERT(nchar, 0xFDFF) + '%'

EDIT: oops, (n)char(x) pitfall

right: select * from sys.sysobjects where name like '%' + CONVERT(nchar(1), 0x4800) + '%'

EDIT2:

select * from sys.sysobjects where charindex(CONVERT(nvarchar(1), 0xFDFF), name) > 0

Answer 2

Thanks for all the help Arthur, +1 for you.
I ended up creating a cursor and checking all characters in every row of the table to find the strange 0xFDFF character. I concatenated all ids into a variable and got my list from there.

DECLARE CURSOR ...
....
WHILE @@FETCH_STATUS = 0   
BEGIN   

     Declare @pos int
     set @Pos = 0

     while @Pos <= Len(@Str)
     begin
      if(convert(binary(2), substring(@Str, @pos, 1), 0) = 0xFDFF)
      begin
       set @ids = @ids + ',' + cast(@TheId as varchar)
       --Select @TheId, @Str
       break
      end
      set @Pos = @Pos + 1
     end

       FETCH NEXT FROM db_cursor INTO @TheId, @Str   
END   

CLOSE db_cursor   
DEALLOCATE db_cursor

select @ids