Selecting rows with NULLand BLANK values [message #37709] |
Fri, 22 February 2002 07:42 |
ron
Messages: 50 Registered: July 1999
|
Member |
|
|
Hi,
I have two columns OLD and NEW in a table.
for few rows I have either NULLS or BLANKS values in OLD column, but in NEW there are values.
my function takes values from OLD as parameter and converts them into values (that are in NEW column).
it works for all values of OLD column except NULL and ''(BLANKs), which have corresponding values in NEW column. please advice me how to handle this.
Thanks
|
|
|
|