If a record returns null for a particular field I would like to insert -1 into that row. How is this done?
Select * from aTable where aField = 'aValue'
afield may have aValue in every row but bField will have null in many rows. I would like to insert -1 into those rows.
Thank you for any assistance