Hi - I'm attempting to update a database so that all fields in a specified column that have a null value and are of datatype number are allocated a value of 0 (zero), but I'm having trouble selecting the offending rows..
my statement is
"select * from crossings where pipeline_id = null"
and this returns nothing (although I know there are some in there because if i run the following:
"select * from crossings where pipeline_id <> null"
it returns all rows that have a value and omits those that don't (ie the ones that I want)
Anyone know what I'm doing wrong?
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.