City: #replace(url.cityState,"|"," ")#

State: #ucase(url.state)#

Zip Code: #url.zipcode#

select sku, skuDesc from tbl_prd_skus with (nolock) where skuid = and ownerid = and fsl_tablecode =

#_status#SKU: #qrySku.sku#

select product, shortDesc from tbl_prd_products with (nolock) where prodid = and ownerid = and fsl_tablecode =

#_status#Category: #qryProd.product# - #qryProd.shortDesc#

select sku, skuDesc from tbl_prd_skus with (nolock) where skuid = and ownerid = and fsl_tablecode =

Not Buying SKU: #qrySku.sku#

select product, shortDesc from tbl_prd_products with (nolock) where prodid = and ownerid = and fsl_tablecode =

Not Buying Category: #qryProd.product# - #qryProd.shortDesc#

Type: Chains

Type: Independents

Last Purchasing Month: #lsdateformat( url.lastPurchasingMonth, "Mmmm YYYY")#

select cho_name from tbl_cho_operators where cho_id =

GPO: #qryAffiliation.cho_name#

select cho_name from tbl_cho_operators where cho_id =

CMC: #qryAffiliation.cho_name#