select null value into 0(zero)

Hot Topic

Open a report in new window
How do I pass multiple paramters to reporting services?
The 'IBMDADB2.1' provider is not registered on the local machine
replicating the resultset of a view
Errors processing SSAS 2005 Cube against SQL 2000 database
Installing SQL Express 2005 - [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pi
SQL Mobile performance/size problems with WM5 device
Exporting Sql data to MS Access
DTC problem
Auto increment help

SQL Server

Running SQL server 2000 & 2005 side by side
Temporary tables
SQL 2005 Time Sensitive Question
grouping by months
Query notification from Win32
Interactive charts, etc.
Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'
creating a user with dbo access
SQL Server 2005 upgrade advisor - Dimension problem
FullText catalog path in SQL 2K5 connectionString

select null value into 0(zero)

Hi,

can i know how to use a select statement to show the null value record to 0

my select statement is like this.

select orderqty - deliveryqty as outstandqty from Ordertable where orderdate > dateadd(mm, -1, getdate())

so in some case the deliveryqty will be null value due to some reason. can i able to make the value to 0 so the orderqty can -0 to get a value for outstandqty

regads

terence chua




Answer this question

select null value into 0(zero)

  • leungant

    Terence Chua wrote:

    select orderqty - deliveryqty as outstandqty from Ordertable where orderdate > dateadd(mm, -1, getdate())

    Use coalesce or isnull

    something like:

    select orderqty - coalesce(deliveryqty,0)



  • cchandru1974

    Thanks Louis Davidson - SQL Server MVP and EISA,

    both of the answer also can function. thanks a lot.



  • BJW


    Hi
    can you try this

    select orderqty - isnull(deliveryqty,0) as outstandqty from Ordertable where orderdate > dateadd(mm, -1, getdate())




  • select null value into 0(zero)
Answer this question