MS SQL Server :: How To Write Select Statement Inside CASE Statement ?

Select Case Inside Sql Statement ? Code: function findingcinemaid(nameofthecinema) findcinemaid = "select cinemasid from cinemas" &_" where brand = 'tgv' and cinemaplace2 like '"&nameofthecinema&"'" set cinemaidfound = objconndb.execute (findcinemaid)

www.bigresource.com