ASE, SQL, OLE, ADE

Reply
Distinguished Contributor
petervose
Posts: 309
Registered: ‎10-02-2003
Message 1 of 2 (329 Views)

ADOLisp - Select rows with null values

329 Views, 1 Replies
01-02-2013 10:19 AM

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?

Distinguished Contributor
petervose
Posts: 309
Registered: ‎10-02-2003
Message 2 of 2 (320 Views)

Re: ADOLisp - Select rows with null values

01-03-2013 02:07 AM in reply to: petervose

Realised I should use keyword "IS" instead of using "="

select * from crossings where pipeline_id IS null

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community