Re: IF Statement help in SQL

Lucy Chew schrieb:

> Hi,
>
> Can anyone please inform on how i can use an IF statement in the
> following code to bring in Addr_Country field but only when the
> address4 is blank (and input into were address4 should b, had it not
> been blank)- if not blank i dont want it to be brought in, i want it
> to be left as address4.
>

       SELECT     apps.payroll_area
                 ,apps.employee_number
                 ,apps.address1
                 ,apps.address2
                 ,apps.address3
                 ,nvl(apps.address4,apps.addr_country)
                 ,apps.postcode
       FROM      apps.xxhrs_person_v     apps