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