thenone
asked on
sql delete question
this connn.execute"delete from table where column = ' ' "
or connn.execute "delete from table where column = null"
both of these are not deleting?
I checked the table and that column is null?
or connn.execute "delete from table where column = null"
both of these are not deleting?
I checked the table and that column is null?
DELETE FROM Table WHERE Column IS NULL
ASKER
and what if it is "" or contains a . that I want to delete same thing?
Add some ORs.
DELETE FROM Table WHERE Column IS NULL OR Column = '' OR Column = '.'
DELETE FROM Table WHERE Column IS NULL OR Column = '' OR Column = '.'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh ok so if the column is blank then = ' ' would work thanks its only when its null do you need to do is null.