KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using SQLite database. My table has a text column called "Password". Earlier for retrieving the values I used to execute a simple select * from myTable query. But now the requirement is that if Password value is not NULL then I need to show it as "Yes" or otherwise "No". It's something like: select * from myTable if Password != NULL then Password = 'Yes' else Password = 'No' I searched a lot regarding this but I didn't get any proper link or example. Any help or suggestion would be really appreciated.
Tags (comma-separated)
Save Edits
Cancel