This can be changed to 0/1 through using CASE WHEN like this example:

Hi friend in this article i will explain you how to convert 0/1 into true and false.



SELECT
 CASE WHEN Users.IsDeleted = 0  THEN 'false' ELSE 'true' END AS 'IsActive'
 FROM Users


Using the above query you can get result as you expected Users = Table name,IsDeleted =column name and IsActive= My Alien Name(display name)



Thank you,