Try IFNULL
HTH
Dan Crawford
Integrated Network Strategies
-Original Message-
From: SankaraNarayanan Mahadevan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 30, 2001 9:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Null Value In a Column
Hi,
I want to select record
Hi,
I want to select record from a table that return empty
string or something else that i want, if a column
contains null value.
can we do that in a select statement.
I tried IsNUll function but it return wither 1 or 0.
In MS SQL Server u got a function IsNULL that accepts
2 parameter - first