title: Query to Find double byte character record
body: <p>I have a table which contains double byte character records in the <code>FORMAT</code> column. I want to find which record contains double byte character? Is there any query to find the double byte character records? </p>
  
  <p>I used the below query to find the records, but it returns both single and double byte character records in the <code>format</code> column.</p>
  
  <pre><code>select * from Product_Details
  where language='JP' and convert(nvarchar(max),convert(varchar(max),FORMAT)) = FORMAT
  </code></pre>
  
  <p>-- Create Product_Details which has NVARchar column format</p>
  
  <pre><code>CREATE TABLE Product_Details
   (Language varchar(2), format NVarchar(max))
  GO 
  </code></pre>
  
  <p>--Populate Product_Details with single byte and 
  --double byte in Format column </p>
  
  <pre><code>INSERT INTO Product_Details (Language, format) 
  VALUES ('EN', 'Basavaraj')
   
  INSERT INTO Product_Details (Language, format) 
  VALUES ('JP', N'尊敬卿')
   
  INSERT INTO Product_Details (Language, format) 
  VALUES ('EN', 'Biradar')
  
  Insert into product_details(Language,format)
     values('CN','你好')
  </code></pre>
  
  <p>Now i want to list records which format column contains double byte character data(for example Japanese language,Chinese language records..).The table contains lot of Chinese and Japanese language records.so i am trying to find out
  which format column contains this records.</p>
  
  <p>Required Output</p>
  
  <pre><code>Language         Format
   JP               尊敬卿
   CN               你好 
  </code></pre>
  
  <p>GO</p>