Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2001
    Location
    FRANCE
    Posts
    25

    Unanswered: Exclude columns from a select statement

    Hi,

    Simple question:

    Is there any way to exclude some columns with a SELECT Table1.* statement?

    Thanks for any infos

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    nope.
    You can name the columns that you wish to return or create a dynamic sql statement with the columns in.

    It is considered bad practise to use select * for returning data.

  3. #3
    Join Date
    Jan 2002
    Posts
    13
    For example:

    table collums: id - name - adress - phone

    If you wish select only name you can use the following query:

    "SELECT name FROM table"

    To add new collums you must add it and put behind a "," like:

    "SELECT name,phone FROM table"


    [ ]'s
    Pedro Henrique Nunes
    MCP-MCP+I-MCSENT4-MCSEW2K
    Sao Paulo - Brasil

  4. #4
    Join Date
    Oct 2001
    Location
    FRANCE
    Posts
    25
    Hi,

    In fact, I've an HUGE view with many column and i have to select all the fields without the description ones for a translation process. I'm forced to use SELECT Col1, Col2 ,,,,,, Col30... FROM View.

    If a such notation exist I just have to write SELECT all appart(Col20,Col22,Col25) FROM View

    Thanks anyway for answers

Posting Permissions

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