SELECT QUERY with Exist or Not Exist

 IF NOT EXISTS(select batch_code from TBL_BATCH_EXTEND where batch_code='BATCH-HR-00005-DB')

print 'true'

else

print 'false'