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

by

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

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

More Related Contents:

  1. Insert an image in a column of a table that already has 5 columns
  2. Get top 1 row of each group
  3. SQL update query using joins
  4. Referring to a Column Alias in a WHERE Clause
  5. SQL query to select dates between two dates
  6. Convert Month Number to Month Name Function in SQL
  7. How to avoid the “divide by zero” error in SQL?
  8. Selecting COUNT(*) with DISTINCT
  9. Querying data by joining two tables in two database on different servers
  10. Generate a resultset of incrementing dates in TSQL
  11. Real life example, when to use OUTER / CROSS APPLY in SQL
  12. Getting result of dynamic SQL into a variable for sql-server
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. What’s the best way to select the minimum value from several columns?
  16. Splitting delimited values in a SQL column into multiple rows
  17. varbinary to string on SQL Server
  18. How to insert a blob into a database using sql server management studio
  19. SQL GROUP BY CASE statement with aggregate function
  20. separate comma separated values and store in table in sql server
  21. SQL Server 2005 ROW_NUMBER() without ORDER BY
  22. Can an INNER JOIN offer better performance than EXISTS
  23. How to check which locks are held on a table
  24. Execution sequence of Group By, Having and Where clause in SQL Server?
  25. How to find sum of multiple columns in a table in SQL Server 2005?
  26. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  27. Is it possible to execute a text file from SQL query?
  28. Query times out from web app but runs fine from management studio
  29. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment