How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?

Question

I have a table with a couple thousand rows. The description and summary fields are NTEXT, and sometimes have non-ASCII chars in them. How can I locate all of the rows with non ASCII characters?

Answer 1

I have sometimes been using this "cast" statement to find "strange" chars

select      * from      <Table> where      <Field> != cast(<Field> as varchar(1000))