Cacher is the code snippet organizer for pro developers

select a.product_description,
substring(a.product_description,charindex('"',a.product_description),15)
--substring(a.product_description,charindex('"',a.product_description),charindex('"',a.product_description))
--patindex('"',a.product_description)
  from import.input_cp as a