Link to home
Start Free TrialLog in
Avatar of thenone
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?
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

DELETE FROM Table WHERE Column IS NULL
Avatar of thenone
thenone

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 = '.'

ASKER CERTIFIED SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thenone

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.