Re: Ignoring Rows with Empty Fields?

["Kronin555" <webforumsuser@xxxxxxxxxxxxxx>]

Why not just do:
 <cfquery name="getsimilar" datasource="#datasource#" maxrows="5">
 SELECT catshortname, soshortname, retailer_name
 FROM merchants
 WHERE soshortname is not null and soshortname != ''
 AND catshortname='#getmerchant.catshortname#'
 ORDER BY retailer_name ASC
 </cfquery>

 The reason there's 2 checks is I'm not sure if you're storing empty values as 
nulls or empty strings.