Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Obtain only alphabets from table

    There is a table name "testtable". This table has three columns col1(char), col2(int) and col3(char). The data in the table will be as mentioned below:

    ------------------------------------------
    Col1 Col2 Col3
    0 0 0
    1 1 1
    2 2 2
    3 3 3
    4 4 4
    5 5 5
    6 6 6
    7 7 7
    8 8 8
    9 9 9
    a 10 A
    A 11 A
    b 12 B
    B 13 B
    c 14 C
    C 15 C
    ------------------------------------------

    How can i get only the alphabets and not numerics from Col3 with the order by caluse on Col2?

    The result should be as follows:
    A
    B
    C

    Please help me out to obtain the result as mentioned above.
    Thanks in advance

    Thanks,
    Reddy

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    SELECT * FROM testtable WHERE col3 IN ('A','B','C','D', ... ,'Z') ORDER BY col3

    Replace "..." with character you would like to include in SQL.

    Hope this helps,
    Grofaty
    Last edited by grofaty; 06-30-04 at 04:32.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    col3 between 'A' and 'Z' will also work, I guess
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    sathyaram_s this is good idea, but if you have non-english environment you will have to specify also non-english charachters!!! So yug229 if you are from english region then you shoud use sathyaram_s tip, else use my tip.

    Hope this helps,
    Grofaty
    Last edited by grofaty; 06-30-04 at 05:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •