Hindi text in nText column SQL Server 2005

[pawangargmit]

We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column.
This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded.

Please suggest how to write a query to know the count for all the rows having Hindi text.

Pawan Garg

[__avd]

UNICODE .
Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.

SELECT     
  UNICODE(SUBSTRING(colName, 1, 1)) 
FROM  TABLENAME