Re: Ignoring Rows with Empty Fields?

["Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>]

[q][i]Originally posted by: [b][b]Kronin555[/b][/b][/i]
 DOH! Right you are, Dan. I was thinking the opposite when I wrote that, which, 
if you store empty fields as nulls or empty strings and don't have consistency, 
in order to get records that have blank fields in that column you'd need to 
check for:
 soshortname is null or soshortname = ''

 However, that's rectified if you just consistently store empty strings as 
nulls.[/q]
 Sometimes you want to story empty strings as empty strings.  If you ever think 
you want to concatonate that field with something else, empty strings would be 
better.