1
Answer

Handling empty string or null values

Marius Vasile

Marius Vasile
1y
548
1

I am having the following issue. In a table I have a string which by default is empty, type nvarchar(2). When I run select query, it does not display any data despite I have filled the table if in WHERE condition I put that column. See below the sql query

DataList1.DataSource = GetData("SELECT * FROM (SELECT TOP 1 * FROM tblTestDetail) td JOIN tblIntrebare ti ON td.IdIntrebare = ti.IdIntrebare WHERE (td.Corect IS NULL OR td.Corect='')");
if (DataList1 != null)
{
    DataList1.DataBind();
}
else
{
    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('No Data')", true);
}

If I use the same query but WHERE condition td.Corect='NU' I get the data displayed. What am I doing wrong?

Answers (1)
Next Recommended Forum