TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
8
)
C - Sharp book or pdf
How to count valid data and invalid data save in excel sheet