P-Line Fluorocarbon 250 yards
$19.99 to $22.99
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = 'SFC250-2' AND (upper(f.web_text) = 'P-LINE' or upper(f.orig_text) = 'P-LINE' or upper(a.brand) = 'P-LINE') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
P-Line Fluorocarbon is extruded from the highest quality Japanese fluorocarbon crystals, ensuring the best knot and breaking strength available in a soft fluorocarbon line. As the educated angler knows, fluorocarbon has a refractive index very close to that of water, making it invisible once it enters the water.
Because of its inherent qualities, this line absorbs very little water giving it great knot strength. Another benefit is the low stretch factor, allowing increased sensitivity to feel the lightest strikes.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$4.69 to $6.89
$2.97 to $7.39
$4.59 to $6.89
$5.09 to $5.19
$12.99 to $13.99
$5.29 to $9.69