If Value is less than zero make the value 1

Transact-SQL
1

Ok I have a view and I want the program to automatically make any negative values a 1 when the data is queried.

So if the value is -2.65 I want it to be a positive 1. Hopefully this makes sense.

Thanks in advance

2

In your view replace the column with
CASE WHEN theColumn < 0 THEN 1 ELSE theColumn END

1 Like