the ISNULL function 1

[chrismccall]

Hi people!

I was wondering is there a way to get around a zero '0' value being put into a record when you use the ISNULL function..

At present isnull(Org_streetno, '') throws up '0' were a 'NULL' value once was... although this is slightly better unfortunately, for the purpose of addresses i.e. a street number for a person on the list can't be seen 2 have the street number '0'.

If possible i would like a blank but without changing the the field property, so that, that column only allows interger values. and no letters!!

cheers

chris

 

[r937]

you can't have a blank for a numeric field

i think your column should be character anyway

what about street numbers like 221b baker street?

(Sherlock Holmes and Doctor Watson lived at 221b Baker Street between 1881-1904, according to the stories written by Sir Arthur Conan Doyle)

change your datatype and you don't have the ISNULL problem


rudy