Abdalla Elawad

Abdalla Elawad

  • NA
  • 1k
  • 215k

how to change a Boolean value sql server

Oct 18 2018 2:56 AM
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

Answers (8)