Post reply

Select non-English records only

  • December 13, 2009 at 4:23 am

    #137636

    Dear all,

    I have a table with Arabic,English and numbers records and I need to select all the arabic records only, can any one give me a query which can do this?? 😉

    Thank in advance...

  • December 13, 2009 at 4:55 am

    #1091625

    Please provide table structure and sample data as described in the first link in my signature.

    Since we don't know the structure of your table, one answer might be:

    SELECT [columns] FROM YourTable WHERE Type = 'Arabic'

    This would assume that you actually stored the type in a separate column. If not, please provide more details.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 13, 2009 at 5:01 am

    #1091626

    Thank you for your reply.

    I dont have type column.

    Assume its only one column containing 100 rows some arabic words, some english word and some numbers.

    I need to select only the arabic words.

    For example, there is "ISNUMERIC(columnName)" which returns 1 if true and 0 if false.

    Is there something like this??

    😉

  • December 13, 2009 at 5:08 am

    #1091627

    As asked for before: table def and some sample data, please.

    Preferred in a ready to use format as described in the aforementioned article.

    And no, there is no function like IsArabic().


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 13, 2009 at 5:18 am

    #1091628

    I know there is no IsArabic(). is there any way to do so??

    my table is ONLY 1 field containing arabic, english and numbers.

    example(every row shows a record in my table):

    ????????

    ??????

    ?????

    2005/12/14

    left

    staha@ahram.org.eg

    586.04

    ???????

  • December 14, 2009 at 12:25 am

    #1091774

    You probably need to search for rows that contain the unicode codes for Arabic. Search Books Online for the functions related to Unicode string handling.

  • December 15, 2009 at 8:24 am

    #1092564

    If you provide a table definition and sample data in a ready to use format you're likely to get more help more quickly. See the 'How to post...' link in my sig below.

    Based on the minimal information you've given this may help:

    select field1 , type =

    case when left(field1,1) BETWEEN '0' AND '9' then 'Numeric'

    when upper(left(field1,1)) BETWEEN 'A' AND 'Z' then 'English'

    else 'Arabic' end

    from sometable

    Nigel
    How to post questions

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply