ms access - Return True if specific value exists in table - sql -


i want create sql query return true if specific value exists in specific column; if not, return false.

i know can create 'select somewhere something'. in case don't want select anything, check.

my question how can it.

you can use iif function:

select iif(something = 'some value', true, false) somewhere; 

Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -