Welcome to Sign in | Help

CASE in WHERE

  •  07-03-2008, 10:51 AM

    CASE in WHERE

    Cum pot sa fac urmatorul select (acum da eroare)
    SELECT * from tabel
    WHERE utilizator IN
    CASE
    WHEN USER_NAME() = 'user1' THEN ('user1', 'user2')
    WHEN USER_NAME() = 'user3' THEN ('user3', 'user2')
    DEFAULT USER_NAME()
    END

    Se poate ?


    Sorin Sandu
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems