ASE, SQL, OLE, ADE

ASE, SQL, OLE, ADE

Reply
Distinguished Contributor
309 Posts
4 Kudos
Registered: ‎10-02-2003
Post 1 of 2

ADOLisp - Select rows with null values

401 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
309 Posts
4 Kudos
Registered: ‎10-02-2003
Post 2 of 2

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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!