excluding rows

[delcoo]

Hi there,

 

I'm really new to mySQL and trying to figure out how to exclude rows with blank values in a particular field from my query.  I guess I just don't know what syntax to use.  I need to select * from account where lastUseDate>=20061201 and corporateName is not blank.  I know the bold part is correct, but how to I exclude blank corporate names?

 

Any help would be appreciated.  I have a "teach yourself mySQL" book here but I can't find any info on this problem

 

Thanks

[artacus]

select * from account where lastUseDate>='2006-12-01'
AND corporateName IS NOT NULL 
AND corporateName <> ''