SQL Delete Where Variable is empty


#1

Hi everyone,

how can I delete a row from an ishare datatable with an execute non query statement where a variable is empty.

I tried

DELETE * FROM [tablename] WHERE [var1] = “” AND [var2] = ‘"+var2+"’

also tried isnull, isempty, isnothing

Thanks for your help!!


#2

is NULL works!