What is wrong ???

24 Nov 2005 10:47 AM

Serhat AKALIN

hi there,

please help me !!!

what is wrong ???

   SELECT CARI.*
               , IF(CARI.CH_UNVANI = '', 'EMPTY' ,CARI.CH_UNVANI)
               , TBLSYSCHTURU.TUR AS CH_TURU
       FROM TBLCARI AS CARI
LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID
ORDER BY CARI.CH_KODU

thanks for advise

24 Nov 2005 10:54 AM

Tibor Karaszi

Use CASE instead of IF.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Serhat AKALIN" <serhataka***@yahoo.com> wrote in message
news:u5klzRO8FHA.4012@TK2MSFTNGP14.phx.gbl...
> hi there,
>
> please help me !!!
>
> what is wrong ???
>
>   SELECT CARI.*
>               , IF(CARI.CH_UNVANI = '', 'EMPTY' ,CARI.CH_UNVANI)
>               , TBLSYSCHTURU.TUR AS CH_TURU
>       FROM TBLCARI AS CARI
> LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID
> ORDER BY CARI.CH_KODU
>
> thanks for advise
>

24 Nov 2005 11:00 AM

Jens

Hi Serhat,

SQL Server doesnt have a sense of "IF", use CASE instead.

   SELECT CARI.*
               , (CASE WHEN CARI.CH_UNVANI = '', 'EMPTY' ELSE
CARI.CH_UNVANI END)
               , TBLSYSCHTURU.TUR AS CH_TURU
       FROM TBLCARI AS CARI
LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID
ORDER BY CARI.CH_KODU

HTH, jens Suessmeyer.

24 Nov 2005 11:05 AM

MC

There is no IF in sql server 2000. You need to use CASE:

SELECT
        CARI.*
        , case when CARI.CH_UNVANI = '' then 'EMPTY' else CARI.CH_UNVANI
end
        , TBLSYSCHTURU.TUR AS CH_TURU
FROM
        TBLCARI AS CARI
        LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID
ORDER BY
        CARI.CH_KOD

Also, avoid using *, put column list instead.

MC

Show quote

"Serhat AKALIN" <serhataka***@yahoo.com> wrote in message
news:u5klzRO8FHA.4012@TK2MSFTNGP14.phx.gbl...
> hi there,
>
> please help me !!!
>
> what is wrong ???
>
>   SELECT CARI.*
>               , IF(CARI.CH_UNVANI = '', 'EMPTY' ,CARI.CH_UNVANI)
>               , TBLSYSCHTURU.TUR AS CH_TURU
>       FROM TBLCARI AS CARI
> LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID
> ORDER BY CARI.CH_KODU
>
> thanks for advise
>