Task:

List all products with a column that indicates bottle packaging.

Click here for details on CHARINDEX.

78 Records

ProductName	Is Bottled
Chai	n/a
Chang	Bottles
Aniseed Syrup	Bottles
Chef Anton's Cajun Seasoning	n/a
Chef Anton's Gumbo Mix	n/a
Grandma's Boysenberry Spread	n/a
Uncle Bob's Organic Dried Pears	n/a
Northwoods Cranberry Sauce	n/a
Mishi Kobe Niku	n/a
Ikura	n/a
Queso Cabrales	n/a
Queso Manchego La Pastora	n/a
Konbu	n/a
Tofu	n/a
Genen Shouyu	Bottles
Pavlova	n/a
Alice Mutton	n/a
Carnarvon Tigers	n/a
Teatime Chocolate Biscuits	n/a
Sir Rodney's Marmalade	n/a
Sir Rodney's Scones	n/a
Gustaf's Knäckebröd	n/a
Tunnbröd	n/a
Guaraná Fantástica	n/a
NuNuCa Nuß-Nougat-Creme	n/a
Gumbär Gummibärchen	n/a
Schoggi Schokolade	n/a
Rössle Sauerkraut	n/a
Thüringer Rostbratwurst	n/a
Nord-Ost Matjeshering	n/a
Gorgonzola Telino	n/a
Mascarpone Fabioli	n/a
Geitost	n/a
Sasquatch Ale	Bottles
Steeleye Stout	Bottles
Inlagd Sill	n/a
Gravad lax	n/a
Côte de Blaye	Bottles
Chartreuse verte	Bottles
Boston Crab Meat	n/a
Jack's New England Clam Chowder	n/a
Singaporean Hokkien Fried Mee	n/a
Ipoh Coffee	n/a
Gula Malacca	n/a
Rogede sild	n/a
Spegesild	n/a
Zaanse koeken	n/a
Chocolade	n/a
Maxilaku	n/a
Valkoinen suklaa	n/a
Manjimup Dried Apples	n/a
Filo Mix	n/a
Perth Pasties	n/a
Tourtière	n/a
Pâté chinois	n/a
Gnocchi di nonna Alice	n/a
Ravioli Angelo	n/a
Escargots de Bourgogne	n/a
Raclette Courdavault	n/a
Camembert Pierrot	n/a
Sirop d'érable	Bottles
Tarte au sucre	n/a
Vegie-spread	n/a
Wimmers gute Semmelknödel	n/a
Louisiana Fiery Hot Pepper Sauce	Bottles
Louisiana Hot Spiced Okra	n/a
Laughing Lumberjack Lager	Bottles
Scottish Longbreads	n/a
Gudbrandsdalsost	n/a
Outback Lager	Bottles
Flotemysost	n/a
Mozzarella di Giovanni	n/a
Röd Kaviar	n/a
Longlife Tofu	n/a
Rhönbräu Klosterbier	Bottles
Lakkalikööri	n/a
Original Frankfurter grüne Soße	n/a
Stroopwafels	n/a

SQL Charindex Position Example

Task: