Newbie Question: how do i show a modified result, depending on its worth

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hebbel
    New Member
    • Oct 2005
    • 1

    Newbie Question: how do i show a modified result, depending on its worth

    Hi,

    i need a sql statement to select data and then modify it, depending whether it's 0 or not

    sample date:
    name, hours, weekday
    ---------------------
    name1, 0.0, monday
    name2, 2.5, monday
    name1, 1.0, tuesday
    name2, 0.0, tuesday
    etc

    the result should be:
    name1, 0.1, monday
    name2, 2.5, monday
    name1, 1.0, tuesday
    name2, 0.1, tuesday

    -> if hours is 0, the result should be 0.1, else hours remains hours

    #######

    thanks for your help
    (and sorry for my english :D . i'm hoping you understand me)
Working...