Re: Ignoring Rows with Empty Fields?

["Kronin555" <webforumsuser@xxxxxxxxxxxxxx>]

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.