how to change a Boolean value sql server

Abdalla Elawad

hello guys

Thank you to support

I create a query in sql servers i need to this 'True' appears (Approved) and False appears (Reject) how can i change this in query .

below the query :

SELECT Requestor_Data.ReqID, Requestor_Data.ReqName, Requestor_Data.ReqCompany, Requestor_Data.ReqMobile, Requestor_Data.City, Requestor_Data.ReqDate,

ApprovedApsgManager.Request_Status

FROM Requestor_Data INNER JOIN

ApprovedApsgManager ON Requestor_Data.ReqID = ApprovedApsgManager.ReqID

WHERE (ApprovedApsgManager.Request_Status = 'TRUE')

* if you need to help more i use this query to dispaly GridView .

THANKS

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munish Kumar8y ago
Accepted answer
Try this:
SELECT Requestor_Data.ReqID, Requestor_Data.ReqName, Requestor_Data.ReqCompany, Requestor_Data.ReqMobile, Requestor_Data.City, Requestor_Data.ReqDate,
CASE WHEN ApprovedApsgManager.Request_Status = 'TRUE' THEN 'Approved' ELSE 'Reject' END
FROM Requestor_Data INNER JOIN
ApprovedApsgManager ON Requestor_Data.ReqID = ApprovedApsgManager.ReqID
WHERE (ApprovedApsgManager.Request_Status = 'TRUE')
Imran Munir8y ago
SELECT Requestor_Data.ReqID, Requestor_Data.ReqName, Requestor_Data.ReqCompany, Requestor_Data.ReqMobile, Requestor_Data.City, Requestor_Data.ReqDate,
iif(ApprovedApsgManager.Request_Status=True,'Approved','Reject') as Request_Status
FROM Requestor_Data INNER JOIN
ApprovedApsgManager ON Requestor_Data.ReqID = ApprovedApsgManager.ReqID
WHERE (ApprovedApsgManager.Request_Status = 'TRUE')
Abdalla Elawad8y ago
Thanks Mr Munish

Solved Problem by ur query
Abdalla Elawad8y ago
Thank a lot Mr. Uttman
I solved this problem inside of the GridView like below code :

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridViewRow GV_Row = e.Row as GridViewRow;
DataRowView DR_Row = GV_Row.DataItem as DataRowView;
if ((bool)DR_Row.Row.ItemArray[0] == true)
{
GV_Row.Cells[0].Text = "APPROVED";
}
else
{
GV_Row.Cells[0].Text = "REJECTED";
}
}
}
Uttam Chaturvedi8y ago
Please have a look into below example:

Remove use END instead of END CASE

SELECT OrderID, Quantity,
CASE
WHEN Quantity > 30 THEN "The quantity is greater than 30"
WHEN Quantity = 30 THEN "The quantity is 30"
ELSE "The quantity is something else"
END
FROM OrderDetails;

If you still get error search for SQL Case statment example, you will find correct syntax
Abdalla Elawad8y ago
iam very sorry MR.Uttman i will try ur query more and more doesn't work
Uttam Chaturvedi8y ago
I modified your query with Case statment. Please try below query, Let me know if you get any issue.
SELECT Requestor_Data.ReqID, Requestor_Data.ReqName, Requestor_Data.ReqCompany, Requestor_Data.ReqMobile, Requestor_Data.City, Requestor_Data.ReqDate,
--ApprovedApsgManager.Request_Status
CASE
WHEN ApprovedApsgManager.Request_Status = 'True' THEN 'Approved'
WHEN ApprovedApsgManager.Request_Status = 'False' THEN 'Rejected'
End
FROM Requestor_Data INNER JOIN
ApprovedApsgManager ON Requestor_Data.ReqID = ApprovedApsgManager.ReqID
WHERE (ApprovedApsgManager.Request_Status = 'TRUE')
It seems END Case is missing. Please add the highlighted END case in query
Abdalla Elawad8y ago
Hello MR. Uttam

Good Idea , but there are specific syntax errors , i make highlight by red

SELECT Requestor_Data.ReqID, Requestor_Data.ReqName, Requestor_Data.ReqCompany, Requestor_Data.ReqMobile, Requestor_Data.City, Requestor_Data.ReqDate,
--ApprovedApsgManager.Request_Status
CASE
WHEN ApprovedApsgManager.Request_Status = 'True' THEN 'Approved'
WHEN ApprovedApsgManager.Request_Status = 'False' THEN 'Rejected'
FROM Requestor_Data INNER JOIN
ApprovedApsgManager ON Requestor_Data.ReqID = ApprovedApsgManager.ReqID
WHERE (ApprovedApsgManager.Request_Status = 'TRUE')