Re: Null values
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 08/17/04
- Next message: Hugo Kornelis: "Re: Sequence"
- Previous message: Loretta: "Null values"
- In reply to: Loretta: "Null values"
- Next in thread: Lorettta: "Re: Null values"
- Reply: Lorettta: "Re: Null values"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Aug 2004 00:39:42 +0200
On Tue, 17 Aug 2004 15:24:44 -0700, Loretta wrote:
>How can I replace null value of a column in a query
>with something like 'TEST'
>
>for eg. if I run the query
>select contract_num, prodid from product
>
>if the contract_num is null, it should return 'TEST'
>instead of NULL. how can I do so?
>
>Thank you,
>-Loretta
Hi Loretta,
SELECT COALESCE(contract_num, 'TEST')
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Hugo Kornelis: "Re: Sequence"
- Previous message: Loretta: "Null values"
- In reply to: Loretta: "Null values"
- Next in thread: Lorettta: "Re: Null values"
- Reply: Lorettta: "Re: Null values"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
