NULL problem?

[asmith]

select * from table where (location1='abcd' or location2='abcd') and userid>56 and userid<72 and username !='none'

 

i have  one line with exactly that option . but that sql line won't find anything , when i remove the "and username !='none'" ,

it works fine . 

i want to tell sql select with that option where user isn't "none" .  so i really need that line . how can i fix it ?

 

( the default field for username is NULL.    so this field can be      NULL, "none" , and variation of words . )

 

i want it to detect NULL too  , only none is not allowed

 

how can i acheive this ?

[asmith]

hmm i guess i can do it with :

 

select * from table where (location1='abcd' or location2='abcd') and userid>56 and userid<72 and username !='none' or username is null

 

works fine  ! but seems a little wierd for me lol