SQLite syntax for If Else condition

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.