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)