RE: Null Value In a Column

2001-12-30 Thread Dan Crawford
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

Null Value In a Column

2001-12-30 Thread SankaraNarayanan Mahadevan
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