locked
filtering Company with Chinese or Japanese Characters RRS feed

  • Question

  •  

    Hi

     

    Can you someone advise how i can filter chinese or japanese characters on Company names.

    I have a list of 40000 company but i want to filter those that display a chinese or japanese characters in the company name.

     

    Appreciated any advise.

     

    Regards

    Andrew

    Tuesday, September 16, 2008 2:53 AM

Answers

  • You have to filter where the company name contains any nchar (using the NCHAR function) from NCHAR(0x4E00) to NCHAR(0x9FFF), which is chinese. Not sure about japanese though.

    Saturday, September 27, 2008 1:44 PM

All replies

  • You have to filter where the company name contains any nchar (using the NCHAR function) from NCHAR(0x4E00) to NCHAR(0x9FFF), which is chinese. Not sure about japanese though.

    Saturday, September 27, 2008 1:44 PM
  •  

    Thanks tican, i will get that a go
    Monday, September 29, 2008 5:23 AM