Welcome to Sign in | Help

Re: CASE in WHERE

  •  07-03-2008, 11:19 AM

    Re: CASE in WHERE

    Workaround :

    select * from tabel
    where USER_NAME() = 'user1' and utilizator in ('user1', 'user2')
    union all
    select * from tabel
    where USER_NAME() = 'user2' and utilizator in ('user3', 'user2')
    union all
    select * from tabel
    where utilizator  = USER_NAME()





    Ignat Andrei
    http://serviciipeweb.ro/iafblog
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems