no value [message #1700] |
Thu, 23 May 2002 13:03 |
lerone streeter
Messages: 2 Registered: May 2002
|
Junior Member |
|
|
i'm trying to do a select, the colums in my where clause are a date and numeric. i want to see all records where no value is entered in the date or numeric field. i've tried coverting them using to_char and comparing against ' ' but it doesn't return results. if i say <> ' ' i get results. what must i use to represent blank?
select f1, f2, f3 from table where f9=' ' and f10=' ';
select f1, f2, f3 from table where to_char(f9)=' ' and to_char(f10)=' ';
|
|
|
|
|
|