Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    53

    Unanswered: select statement

    hi all

    can someone tell me how ido this

    i have select statemnet

    select fielda, fieldb, fieldc from table but i want to do this


    select fielda, fieldb, fieldc, selected='true' from table

    how do i do the setting a value to the selected col. that doens't exist in a table

    many thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    select fielda, fieldb, fieldc
    , 'true' as selected
    from daTable
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2004
    Posts
    53
    thanks - didn't realise it's so easy !

Posting Permissions

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