LINQ To SQL Samples - String/Date FunctionsOn This Page |
This sample uses the & operator to concatenate string fields and string literals in forming the Customers' calculated Location value.
Public Sub LinqToSqlString01()
Dim q = From c In db.Customers _
Select c.CustomerID, Location = c.City & ", " & c.Country
ObjectDumper.Write(q, 1)
End Sub
Result:
CustomerID=ALFKI Location=Berlin, Germany
CustomerID=ANATR Location=México D.F., Mexico
CustomerID=ANTON Location=México D.F., Mexico
CustomerID=AROUT Location=London, UK
CustomerID=BERGS Location=Luleå, Sweden
CustomerID=BLAUS Location=Mannheim, Germany
CustomerID=BLONP Location=Strasbourg, France
CustomerID=BOLID Location=Madrid, Spain
CustomerID=BONAP Location=Marseille, France
CustomerID=BOTTM Location=Tsawassen, Canada
CustomerID=BSBEV Location=London, UK
CustomerID=CACTU Location=Buenos Aires, Argentina
CustomerID=CENTC Location=México D.F., Mexico
CustomerID=CHOPS Location=Bern, Switzerland
CustomerID=COMMI Location=Sao Paulo, Brazil
CustomerID=CONSH Location=London, UK
CustomerID=DRACD Location=Aachen, Germany
CustomerID=DUMON Location=Nantes, France
CustomerID=EASTC Location=London, UK
CustomerID=ERNSH Location=Graz, Austria
CustomerID=FAMIA Location=Sao Paulo, Brazil
CustomerID=FISSA Location=Madrid, Spain
CustomerID=FOLIG Location=Lille, France
CustomerID=FOLKO Location=Bräcke, Sweden
CustomerID=FRANK Location=München, Germany
CustomerID=FRANR Location=Nantes, France
CustomerID=FRANS Location=Torino, Italy
CustomerID=FURIB Location=Lisboa, Portugal
CustomerID=GALED Location=Barcelona, Spain
CustomerID=GODOS Location=Sevilla, Spain
CustomerID=GOURL Location=Campinas, Brazil
CustomerID=GREAL Location=Eugene, USA
CustomerID=GROSR Location=Caracas, Venezuela
CustomerID=HANAR Location=Rio de Janeiro, Brazil
CustomerID=HILAA Location=San Cristóbal, Venezuela
CustomerID=HUNGC Location=Elgin, USA
CustomerID=HUNGO Location=Cork, Ireland
CustomerID=ISLAT Location=Cowes, UK
CustomerID=KOENE Location=Brandenburg, Germany
CustomerID=LACOR Location=Versailles, France
CustomerID=LAMAI Location=Toulouse, France
CustomerID=LAUGB Location=Vancouver, Canada
CustomerID=LAZYK Location=Walla Walla, USA
CustomerID=LEHMS Location=Frankfurt a.M., Germany
CustomerID=LETSS Location=San Francisco, USA
CustomerID=LILAS Location=Barquisimeto, Venezuela
CustomerID=LINOD Location=I. de Margarita, Venezuela
CustomerID=LONEP Location=Portland, USA
CustomerID=MAGAA Location=Bergamo, Italy
CustomerID=MAISD Location=Bruxelles, Belgium
CustomerID=MEREP Location=Montréal, Canada
CustomerID=MORGK Location=Leipzig, Germany
CustomerID=NORTS Location=London, UK
CustomerID=OCEAN Location=Buenos Aires, Argentina
CustomerID=OLDWO Location=Anchorage, USA
CustomerID=OTTIK Location=Köln, Germany
CustomerID=PARIS Location=Paris, France
CustomerID=PERIC Location=México D.F., Mexico
CustomerID=PICCO Location=Salzburg, Austria
CustomerID=PRINI Location=Lisboa, Portugal
CustomerID=QUEDE Location=Rio de Janeiro, Brazil
CustomerID=QUEEN Location=Sao Paulo, Brazil
CustomerID=QUICK Location=Cunewalde, Germany
CustomerID=RANCH Location=Buenos Aires, Argentina
CustomerID=RATTC Location=Albuquerque, USA
CustomerID=REGGC Location=Reggio Emilia, Italy
CustomerID=RICAR Location=Rio de Janeiro, Brazil
CustomerID=RICSU Location=Genève, Switzerland
CustomerID=ROMEY Location=Madrid, Spain
CustomerID=SANTG Location=Stavern, Norway
CustomerID=SAVEA Location=Boise, USA
CustomerID=SEVES Location=London, UK
CustomerID=SIMOB Location=Kobenhavn, Denmark
CustomerID=SPECD Location=Paris, France
CustomerID=SPLIR Location=Lander, USA
CustomerID=SUPRD Location=Charleroi, Belgium
CustomerID=THEBI Location=Portland, USA
CustomerID=THECR Location=Butte, USA
CustomerID=TOMSP Location=Münster, Germany
CustomerID=TORTU Location=México D.F., Mexico
CustomerID=TRADH Location=Sao Paulo, Brazil
CustomerID=TRAIH Location=Kirkland, USA
CustomerID=VAFFE Location=Århus, Denmark
CustomerID=VICTE Location=Lyon, France
CustomerID=VINET Location=Reims, France
CustomerID=WANDK Location=Stuttgart, Germany
CustomerID=WARTH Location=Oulu, Finland
CustomerID=WELLI Location=Resende, Brazil
CustomerID=WHITC Location=Seattle, USA
CustomerID=WILMK Location=Helsinki, Finland
CustomerID=WOLZA Location=Warszawa, Poland
This sample uses the Length property to find all Products whose name is shorter than 10 characters.
Public Sub LinqToSqlString02()
Dim q = From p In db.Products _
Where p.ProductName.Length < 10 _
Select p
ObjectDumper.Write(q)
End Sub
Result:
ProductID=1 ProductName=Chai SupplierID=1 CategoryID=1 QuantityPerUnit=10 boxes x 20 bags UnitPrice=18.0000 UnitsInStock=39 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=2 ProductName=Chang SupplierID=1 CategoryID=1 QuantityPerUnit=24 - 12 oz bottles UnitPrice=19.0000 UnitsInStock=17 UnitsOnOrder=40 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=10 ProductName=Ikura SupplierID=4 CategoryID=8 QuantityPerUnit=12 - 200 ml jars UnitPrice=32.0000 UnitsInStock=31 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=13 ProductName=Konbu SupplierID=6 CategoryID=8 QuantityPerUnit=2 kg box UnitPrice=7.0000 UnitsInStock=24 UnitsOnOrder=0 ReorderLevel=5 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=14 ProductName=Tofu SupplierID=6 CategoryID=7 QuantityPerUnit=40 - 100 g pkgs. UnitPrice=24.2500 UnitsInStock=35 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=16 ProductName=Pavlova SupplierID=7 CategoryID=3 QuantityPerUnit=32 - 500 g boxes UnitPrice=18.4500 UnitsInStock=29 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=23 ProductName=Tunnbröd SupplierID=9 CategoryID=5 QuantityPerUnit=12 - 250 g pkgs. UnitPrice=10.0000 UnitsInStock=61 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=33 ProductName=Geitost SupplierID=15 CategoryID=4 QuantityPerUnit=500 g UnitPrice=3.5000 UnitsInStock=112 UnitsOnOrder=0 ReorderLevel=20 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=46 ProductName=Spegesild SupplierID=21 CategoryID=8 QuantityPerUnit=4 - 450 g glasses UnitPrice=13.0000 UnitsInStock=95 UnitsOnOrder=0 ReorderLevel=0 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=48 ProductName=Chocolade SupplierID=22 CategoryID=3 QuantityPerUnit=10 pkgs. UnitPrice=13.7500 UnitsInStock=15 UnitsOnOrder=70 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=49 ProductName=Maxilaku SupplierID=23 CategoryID=3 QuantityPerUnit=24 - 50 g pkgs. UnitPrice=21.0000 UnitsInStock=10 UnitsOnOrder=60 ReorderLevel=15 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=52 ProductName=Filo Mix SupplierID=24 CategoryID=5 QuantityPerUnit=16 - 2 kg boxes UnitPrice=8.0000 UnitsInStock=38 UnitsOnOrder=0 ReorderLevel=25 Discontinued=False Order_Details=... Category={ } Supplier={ }
ProductID=54 ProductName=Tourtière SupplierID=25 CategoryID=6 QuantityPerUnit=16 pies UnitPrice=8.4500 UnitsInStock=21 UnitsOnOrder=0 ReorderLevel=10 Discontinued=False Order_Details=... Category={ } Supplier={ }
This sample uses the Contains method to find all Customers whose contact name contains 'Anders'.
Public Sub LinqToSqlString03()
Dim q = From c In db.Customers _
Where c.ContactName.Contains("Anders") _
Select c
ObjectDumper.Write(q)
End Sub
Result:
CustomerID=ALFKI CompanyName=Alfreds Futterkiste ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Phone=030-0074321 Fax=030-0076545 Orders=... CustomerCustomerDemos=...
This sample uses the IndexOf method to find the first instance of a space in each Customer's contact name.
Public Sub LinqToSqlString04()
Dim q = From c In db.Customers _
Select c.ContactName, SpacePos = c.ContactName.IndexOf(" ")
ObjectDumper.Write(q)
End Sub
Result:
ContactName=Maria Anders SpacePos=5
ContactName=Ana Trujillo SpacePos=3
ContactName=Antonio Moreno SpacePos=7
ContactName=Thomas Hardy SpacePos=6
ContactName=Christina Berglund SpacePos=9
ContactName=Hanna Moos SpacePos=5
ContactName=Frédérique Citeaux SpacePos=10
ContactName=Martín Sommer SpacePos=6
ContactName=Laurence Lebihan SpacePos=8
ContactName=Elizabeth Lincoln SpacePos=9
ContactName=Victoria Ashworth SpacePos=8
ContactName=Patricio Simpson SpacePos=8
ContactName=Francisco Chang SpacePos=9
ContactName=Yang Wang SpacePos=4
ContactName=Pedro Afonso SpacePos=5
ContactName=Elizabeth Brown SpacePos=9
ContactName=Sven Ottlieb SpacePos=4
ContactName=Janine Labrune SpacePos=6
ContactName=Ann Devon SpacePos=3
ContactName=Roland Mendel SpacePos=6
ContactName=Aria Cruz SpacePos=4
ContactName=Diego Roel SpacePos=5
ContactName=Martine Rancé SpacePos=7
ContactName=Maria Larsson SpacePos=5
ContactName=Peter Franken SpacePos=5
ContactName=Carine Schmitt SpacePos=6
ContactName=Paolo Accorti SpacePos=5
ContactName=Lino Rodriguez SpacePos=4
ContactName=Eduardo Saavedra SpacePos=7
ContactName=José Pedro Freyre SpacePos=4
ContactName=André Fonseca SpacePos=5
ContactName=Howard Snyder SpacePos=6
ContactName=Manuel Pereira SpacePos=6
ContactName=Mario Pontes SpacePos=5
ContactName=Carlos Hernández SpacePos=6
ContactName=Yoshi Latimer SpacePos=5
ContactName=Patricia McKenna SpacePos=8
ContactName=Helen Bennett SpacePos=5
ContactName=Philip Cramer SpacePos=6
ContactName=Daniel Tonini SpacePos=6
ContactName=Annette Roulet SpacePos=7
ContactName=Yoshi Tannamuri SpacePos=5
ContactName=John Steel SpacePos=4
ContactName=Renate Messner SpacePos=6
ContactName=Jaime Yorres SpacePos=5
ContactName=Carlos González SpacePos=6
ContactName=Felipe Izquierdo SpacePos=6
ContactName=Fran Wilson SpacePos=4
ContactName=Giovanni Rovelli SpacePos=8
ContactName=Catherine Dewey SpacePos=9
ContactName=Jean Fresnière SpacePos=4
ContactName=Alexander Feuer SpacePos=9
ContactName=Simon Crowther SpacePos=5
ContactName=Yvonne Moncada SpacePos=6
ContactName=Rene Phillips SpacePos=4
ContactName=Henriette Pfalzheim SpacePos=9
ContactName=Marie Bertrand SpacePos=5
ContactName=Guillermo Fernández SpacePos=9
ContactName=Georg Pipps SpacePos=5
ContactName=Isabel de Castro SpacePos=6
ContactName=Bernardo Batista SpacePos=8
ContactName=Lúcia Carvalho SpacePos=5
ContactName=Horst Kloss SpacePos=5
ContactName=Sergio Gutiérrez SpacePos=6
ContactName=Paula Wilson SpacePos=5
ContactName=Maurizio Moroni SpacePos=8
ContactName=Janete Limeira SpacePos=6
ContactName=Michael Holz SpacePos=7
ContactName=Alejandra Camino SpacePos=9
ContactName=Jonas Bergulfsen SpacePos=5
ContactName=Jose Pavarotti SpacePos=4
ContactName=Hari Kumar SpacePos=4
ContactName=Jytte Petersen SpacePos=5
ContactName=Dominique Perrier SpacePos=9
ContactName=Art Braunschweiger SpacePos=3
ContactName=Pascale Cartrain SpacePos=7
ContactName=Liz Nixon SpacePos=3
ContactName=Liu Wong SpacePos=3
ContactName=Karin Josephs SpacePos=5
ContactName=Miguel Angel Paolino SpacePos=6
ContactName=Anabela Domingues SpacePos=7
ContactName=Helvetius Nagy SpacePos=9
ContactName=Palle Ibsen SpacePos=5
ContactName=Mary Saveley SpacePos=4
ContactName=Paul Henriot SpacePos=4
ContactName=Rita Müller SpacePos=4
ContactName=Pirkko Koskitalo SpacePos=6
ContactName=Paula Parente SpacePos=5
ContactName=Karl Jablonski SpacePos=4
ContactName=Matti Karttunen SpacePos=5
ContactName=Zbyszek Piestrzeniewicz SpacePos=7
This sample uses the StartsWith method to find Customers whose contact name starts with 'Maria'.
Public Sub LinqToSqlString05()
Dim q = From c In db.Customers _
Where c.ContactName.StartsWith("Maria") _
Select c
ObjectDumper.Write(q)
End Sub
Result:
CustomerID=ALFKI CompanyName=Alfreds Futterkiste ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Phone=030-0074321 Fax=030-0076545 Orders=... CustomerCustomerDemos=...
CustomerID=FOLKO CompanyName=Folk och fä HB ContactName=Maria Larsson ContactTitle=Owner Address=Åkergatan 24 City=Bräcke Region=null PostalCode=S-844 67 Country=Sweden Phone=0695-34 67 21 Fax=null Orders=... CustomerCustomerDemos=...
This sample uses the StartsWith method to find Customers whose contact name ends with 'Anders'.
Public Sub LinqToSqlString06()
Dim q = From c In db.Customers _
Where c.ContactName.EndsWith("Anders") _
Select c
ObjectDumper.Write(q)
End Sub
Result:
CustomerID=ALFKI CompanyName=Alfreds Futterkiste ContactName=Maria Anders ContactTitle=Sales Representative Address=Obere Str. 57 City=Berlin Region=null PostalCode=12209 Country=Germany Phone=030-0074321 Fax=030-0076545 Orders=... CustomerCustomerDemos=...
This sample uses the DateTime's Month property to find Orders placed in December.
Public Sub LinqToSqlString17()
Dim q = From o In db.Orders _
Where o.OrderDate.Value.Month = 12
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10369 CustomerID=SPLIR EmployeeID=8 OrderDate=12/2/1996 RequiredDate=12/30/1996 ShippedDate=12/9/1996 ShipVia=2 Freight=195.6800 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10370 CustomerID=CHOPS EmployeeID=6 OrderDate=12/3/1996 RequiredDate=12/31/1996 ShippedDate=12/27/1996 ShipVia=2 Freight=1.1700 ShipName=Chop-suey Chinese ShipAddress=Hauptstr. 31 ShipCity=Bern ShipRegion=null ShipPostalCode=3012 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10371 CustomerID=LAMAI EmployeeID=1 OrderDate=12/3/1996 RequiredDate=12/31/1996 ShippedDate=12/24/1996 ShipVia=1 Freight=0.4500 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10372 CustomerID=QUEEN EmployeeID=5 OrderDate=12/4/1996 RequiredDate=1/1/1997 ShippedDate=12/9/1996 ShipVia=2 Freight=890.7800 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10373 CustomerID=HUNGO EmployeeID=4 OrderDate=12/5/1996 RequiredDate=1/2/1997 ShippedDate=12/11/1996 ShipVia=3 Freight=124.1200 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10374 CustomerID=WOLZA EmployeeID=1 OrderDate=12/5/1996 RequiredDate=1/2/1997 ShippedDate=12/9/1996 ShipVia=3 Freight=3.9400 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10375 CustomerID=HUNGC EmployeeID=3 OrderDate=12/6/1996 RequiredDate=1/3/1997 ShippedDate=12/9/1996 ShipVia=2 Freight=20.1200 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10376 CustomerID=MEREP EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=2 Freight=20.3900 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10377 CustomerID=SEVES EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=3 Freight=22.2100 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10378 CustomerID=FOLKO EmployeeID=5 OrderDate=12/10/1996 RequiredDate=1/7/1997 ShippedDate=12/19/1996 ShipVia=3 Freight=5.4400 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10379 CustomerID=QUEDE EmployeeID=2 OrderDate=12/11/1996 RequiredDate=1/8/1997 ShippedDate=12/13/1996 ShipVia=1 Freight=45.0300 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10380 CustomerID=HUNGO EmployeeID=8 OrderDate=12/12/1996 RequiredDate=1/9/1997 ShippedDate=1/16/1997 ShipVia=3 Freight=35.0300 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10381 CustomerID=LILAS EmployeeID=3 OrderDate=12/12/1996 RequiredDate=1/9/1997 ShippedDate=12/13/1996 ShipVia=3 Freight=7.9900 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10382 CustomerID=ERNSH EmployeeID=4 OrderDate=12/13/1996 RequiredDate=1/10/1997 ShippedDate=12/16/1996 ShipVia=1 Freight=94.7700 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10383 CustomerID=AROUT EmployeeID=8 OrderDate=12/16/1996 RequiredDate=1/13/1997 ShippedDate=12/18/1996 ShipVia=3 Freight=34.2400 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10384 CustomerID=BERGS EmployeeID=3 OrderDate=12/16/1996 RequiredDate=1/13/1997 ShippedDate=12/20/1996 ShipVia=3 Freight=168.6400 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10385 CustomerID=SPLIR EmployeeID=1 OrderDate=12/17/1996 RequiredDate=1/14/1997 ShippedDate=12/23/1996 ShipVia=2 Freight=30.9600 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10386 CustomerID=FAMIA EmployeeID=9 OrderDate=12/18/1996 RequiredDate=1/1/1997 ShippedDate=12/25/1996 ShipVia=3 Freight=13.9900 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10387 CustomerID=SANTG EmployeeID=1 OrderDate=12/18/1996 RequiredDate=1/15/1997 ShippedDate=12/20/1996 ShipVia=2 Freight=93.6300 ShipName=Santé Gourmet ShipAddress=Erling Skakkes gate 78 ShipCity=Stavern ShipRegion=null ShipPostalCode=4110 ShipCountry=Norway Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10388 CustomerID=SEVES EmployeeID=2 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipVia=1 Freight=34.8600 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10389 CustomerID=BOTTM EmployeeID=4 OrderDate=12/20/1996 RequiredDate=1/17/1997 ShippedDate=12/24/1996 ShipVia=2 Freight=47.4200 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10390 CustomerID=ERNSH EmployeeID=6 OrderDate=12/23/1996 RequiredDate=1/20/1997 ShippedDate=12/26/1996 ShipVia=1 Freight=126.3800 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10391 CustomerID=DRACD EmployeeID=3 OrderDate=12/23/1996 RequiredDate=1/20/1997 ShippedDate=12/31/1996 ShipVia=3 Freight=5.4500 ShipName=Drachenblut Delikatessen ShipAddress=Walserweg 21 ShipCity=Aachen ShipRegion=null ShipPostalCode=52066 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10392 CustomerID=PICCO EmployeeID=2 OrderDate=12/24/1996 RequiredDate=1/21/1997 ShippedDate=1/1/1997 ShipVia=3 Freight=122.4600 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10393 CustomerID=SAVEA EmployeeID=1 OrderDate=12/25/1996 RequiredDate=1/22/1997 ShippedDate=1/3/1997 ShipVia=3 Freight=126.5600 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10394 CustomerID=HUNGC EmployeeID=1 OrderDate=12/25/1996 RequiredDate=1/22/1997 ShippedDate=1/3/1997 ShipVia=3 Freight=30.3400 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10395 CustomerID=HILAA EmployeeID=6 OrderDate=12/26/1996 RequiredDate=1/23/1997 ShippedDate=1/3/1997 ShipVia=1 Freight=184.4100 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10396 CustomerID=FRANK EmployeeID=1 OrderDate=12/27/1996 RequiredDate=1/10/1997 ShippedDate=1/6/1997 ShipVia=3 Freight=135.3500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10397 CustomerID=PRINI EmployeeID=5 OrderDate=12/27/1996 RequiredDate=1/24/1997 ShippedDate=1/2/1997 ShipVia=1 Freight=60.2600 ShipName=Princesa Isabel Vinhos ShipAddress=Estrada da saúde n. 58 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1756 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10398 CustomerID=SAVEA EmployeeID=2 OrderDate=12/30/1996 RequiredDate=1/27/1997 ShippedDate=1/9/1997 ShipVia=3 Freight=89.1600 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10399 CustomerID=VAFFE EmployeeID=8 OrderDate=12/31/1996 RequiredDate=1/14/1997 ShippedDate=1/8/1997 ShipVia=3 Freight=27.3600 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10760 CustomerID=MAISD EmployeeID=4 OrderDate=12/1/1997 RequiredDate=12/29/1997 ShippedDate=12/10/1997 ShipVia=1 Freight=155.6400 ShipName=Maison Dewey ShipAddress=Rue Joseph-Bens 532 ShipCity=Bruxelles ShipRegion=null ShipPostalCode=B-1180 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10761 CustomerID=RATTC EmployeeID=5 OrderDate=12/2/1997 RequiredDate=12/30/1997 ShippedDate=12/8/1997 ShipVia=2 Freight=18.6600 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10762 CustomerID=FOLKO EmployeeID=3 OrderDate=12/2/1997 RequiredDate=12/30/1997 ShippedDate=12/9/1997 ShipVia=1 Freight=328.7400 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10763 CustomerID=FOLIG EmployeeID=3 OrderDate=12/3/1997 RequiredDate=12/31/1997 ShippedDate=12/8/1997 ShipVia=3 Freight=37.3500 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10764 CustomerID=ERNSH EmployeeID=6 OrderDate=12/3/1997 RequiredDate=12/31/1997 ShippedDate=12/8/1997 ShipVia=3 Freight=145.4500 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10765 CustomerID=QUICK EmployeeID=3 OrderDate=12/4/1997 RequiredDate=1/1/1998 ShippedDate=12/9/1997 ShipVia=3 Freight=42.7400 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10766 CustomerID=OTTIK EmployeeID=4 OrderDate=12/5/1997 RequiredDate=1/2/1998 ShippedDate=12/9/1997 ShipVia=1 Freight=157.5500 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10767 CustomerID=SUPRD EmployeeID=4 OrderDate=12/5/1997 RequiredDate=1/2/1998 ShippedDate=12/15/1997 ShipVia=3 Freight=1.5900 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10768 CustomerID=AROUT EmployeeID=3 OrderDate=12/8/1997 RequiredDate=1/5/1998 ShippedDate=12/15/1997 ShipVia=2 Freight=146.3200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10769 CustomerID=VAFFE EmployeeID=3 OrderDate=12/8/1997 RequiredDate=1/5/1998 ShippedDate=12/12/1997 ShipVia=1 Freight=65.0600 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10770 CustomerID=HANAR EmployeeID=8 OrderDate=12/9/1997 RequiredDate=1/6/1998 ShippedDate=12/17/1997 ShipVia=3 Freight=5.3200 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10771 CustomerID=ERNSH EmployeeID=9 OrderDate=12/10/1997 RequiredDate=1/7/1998 ShippedDate=1/2/1998 ShipVia=2 Freight=11.1900 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10772 CustomerID=LEHMS EmployeeID=3 OrderDate=12/10/1997 RequiredDate=1/7/1998 ShippedDate=12/19/1997 ShipVia=2 Freight=91.2800 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10773 CustomerID=ERNSH EmployeeID=1 OrderDate=12/11/1997 RequiredDate=1/8/1998 ShippedDate=12/16/1997 ShipVia=3 Freight=96.4300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10774 CustomerID=FOLKO EmployeeID=4 OrderDate=12/11/1997 RequiredDate=12/25/1997 ShippedDate=12/12/1997 ShipVia=1 Freight=48.2000 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10775 CustomerID=THECR EmployeeID=7 OrderDate=12/12/1997 RequiredDate=1/9/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=20.2500 ShipName=The Cracker Box ShipAddress=55 Grizzly Peak Rd. ShipCity=Butte ShipRegion=MT ShipPostalCode=59801 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10776 CustomerID=ERNSH EmployeeID=1 OrderDate=12/15/1997 RequiredDate=1/12/1998 ShippedDate=12/18/1997 ShipVia=3 Freight=351.5300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10777 CustomerID=GOURL EmployeeID=7 OrderDate=12/15/1997 RequiredDate=12/29/1997 ShippedDate=1/21/1998 ShipVia=2 Freight=3.0100 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10778 CustomerID=BERGS EmployeeID=3 OrderDate=12/16/1997 RequiredDate=1/13/1998 ShippedDate=12/24/1997 ShipVia=1 Freight=6.7900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10779 CustomerID=MORGK EmployeeID=3 OrderDate=12/16/1997 RequiredDate=1/13/1998 ShippedDate=1/14/1998 ShipVia=2 Freight=58.1300 ShipName=Morgenstern Gesundkost ShipAddress=Heerstr. 22 ShipCity=Leipzig ShipRegion=null ShipPostalCode=04179 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10780 CustomerID=LILAS EmployeeID=2 OrderDate=12/16/1997 RequiredDate=12/30/1997 ShippedDate=12/25/1997 ShipVia=1 Freight=42.1300 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10781 CustomerID=WARTH EmployeeID=2 OrderDate=12/17/1997 RequiredDate=1/14/1998 ShippedDate=12/19/1997 ShipVia=3 Freight=73.1600 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10782 CustomerID=CACTU EmployeeID=9 OrderDate=12/17/1997 RequiredDate=1/14/1998 ShippedDate=12/22/1997 ShipVia=3 Freight=1.1000 ShipName=Cactus Comidas para llevar ShipAddress=Cerrito 333 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10783 CustomerID=HANAR EmployeeID=4 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/19/1997 ShipVia=2 Freight=124.9800 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10784 CustomerID=MAGAA EmployeeID=4 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/22/1997 ShipVia=3 Freight=70.0900 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10785 CustomerID=GROSR EmployeeID=1 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/24/1997 ShipVia=3 Freight=1.5100 ShipName=GROSELLA-Restaurante ShipAddress=5ª Ave. Los Palos Grandes ShipCity=Caracas ShipRegion=DF ShipPostalCode=1081 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10786 CustomerID=QUEEN EmployeeID=8 OrderDate=12/19/1997 RequiredDate=1/16/1998 ShippedDate=12/23/1997 ShipVia=1 Freight=110.8700 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10787 CustomerID=LAMAI EmployeeID=2 OrderDate=12/19/1997 RequiredDate=1/2/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=249.9300 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10788 CustomerID=QUICK EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=1/19/1998 ShipVia=2 Freight=42.7000 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10789 CustomerID=FOLIG EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=12/31/1997 ShipVia=2 Freight=100.6000 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10790 CustomerID=GOURL EmployeeID=6 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=28.2300 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10791 CustomerID=FRANK EmployeeID=6 OrderDate=12/23/1997 RequiredDate=1/20/1998 ShippedDate=1/1/1998 ShipVia=2 Freight=16.8500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10792 CustomerID=WOLZA EmployeeID=1 OrderDate=12/23/1997 RequiredDate=1/20/1998 ShippedDate=12/31/1997 ShipVia=3 Freight=23.7900 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10793 CustomerID=AROUT EmployeeID=3 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/8/1998 ShipVia=3 Freight=4.5200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10794 CustomerID=QUEDE EmployeeID=6 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/2/1998 ShipVia=1 Freight=21.4900 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10795 CustomerID=ERNSH EmployeeID=8 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/20/1998 ShipVia=2 Freight=126.6600 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10796 CustomerID=HILAA EmployeeID=3 OrderDate=12/25/1997 RequiredDate=1/22/1998 ShippedDate=1/14/1998 ShipVia=1 Freight=26.5200 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10797 CustomerID=DRACD EmployeeID=7 OrderDate=12/25/1997 RequiredDate=1/22/1998 ShippedDate=1/5/1998 ShipVia=2 Freight=33.3500 ShipName=Drachenblut Delikatessen ShipAddress=Walserweg 21 ShipCity=Aachen ShipRegion=null ShipPostalCode=52066 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10798 CustomerID=ISLAT EmployeeID=2 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=1 Freight=2.3300 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10799 CustomerID=KOENE EmployeeID=9 OrderDate=12/26/1997 RequiredDate=2/6/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=30.7600 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10800 CustomerID=SEVES EmployeeID=1 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=137.4400 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10801 CustomerID=BOLID EmployeeID=4 OrderDate=12/29/1997 RequiredDate=1/26/1998 ShippedDate=12/31/1997 ShipVia=2 Freight=97.0900 ShipName=Bólido Comidas preparadas ShipAddress=C/ Araquil, 67 ShipCity=Madrid ShipRegion=null ShipPostalCode=28023 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10802 CustomerID=SIMOB EmployeeID=4 OrderDate=12/29/1997 RequiredDate=1/26/1998 ShippedDate=1/2/1998 ShipVia=2 Freight=257.2600 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10803 CustomerID=WELLI EmployeeID=4 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/6/1998 ShipVia=1 Freight=55.2300 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10804 CustomerID=SEVES EmployeeID=6 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipVia=2 Freight=27.3300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10805 CustomerID=THEBI EmployeeID=2 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/9/1998 ShipVia=3 Freight=237.3400 ShipName=The Big Cheese ShipAddress=89 Jefferson Way Suite 2 ShipCity=Portland ShipRegion=OR ShipPostalCode=97201 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10806 CustomerID=VICTE EmployeeID=3 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/5/1998 ShipVia=2 Freight=22.1100 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10807 CustomerID=FRANS EmployeeID=4 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/30/1998 ShipVia=1 Freight=1.3600 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
This sample uses the DateTime's Day property to find Orders placed on the 31st day of the month.
Public Sub LinqToSqlString18()
Dim q = From o In db.Orders _
Where o.OrderDate.Value.Day = 31 _
Select o
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10269 CustomerID=WHITC EmployeeID=5 OrderDate=7/31/1996 RequiredDate=8/14/1996 ShippedDate=8/9/1996 ShipVia=1 Freight=4.5600 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10343 CustomerID=LEHMS EmployeeID=4 OrderDate=10/31/1996 RequiredDate=11/28/1996 ShippedDate=11/6/1996 ShipVia=1 Freight=110.3700 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10399 CustomerID=VAFFE EmployeeID=8 OrderDate=12/31/1996 RequiredDate=1/14/1997 ShippedDate=1/8/1997 ShipVia=3 Freight=27.3600 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10432 CustomerID=SPLIR EmployeeID=3 OrderDate=1/31/1997 RequiredDate=2/14/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=4.3400 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10490 CustomerID=HILAA EmployeeID=7 OrderDate=3/31/1997 RequiredDate=4/28/1997 ShippedDate=4/3/1997 ShipVia=2 Freight=210.1900 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10491 CustomerID=FURIB EmployeeID=8 OrderDate=3/31/1997 RequiredDate=4/28/1997 ShippedDate=4/8/1997 ShipVia=3 Freight=16.9600 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10616 CustomerID=GREAL EmployeeID=1 OrderDate=7/31/1997 RequiredDate=8/28/1997 ShippedDate=8/5/1997 ShipVia=2 Freight=116.5300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10617 CustomerID=GREAL EmployeeID=4 OrderDate=7/31/1997 RequiredDate=8/28/1997 ShippedDate=8/4/1997 ShipVia=2 Freight=18.5300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10725 CustomerID=FAMIA EmployeeID=4 OrderDate=10/31/1997 RequiredDate=11/28/1997 ShippedDate=11/5/1997 ShipVia=3 Freight=10.8300 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10806 CustomerID=VICTE EmployeeID=3 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/5/1998 ShipVia=2 Freight=22.1100 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10807 CustomerID=FRANS EmployeeID=4 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/30/1998 ShipVia=1 Freight=1.3600 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10987 CustomerID=EASTC EmployeeID=8 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipVia=1 Freight=185.4800 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10988 CustomerID=RATTC EmployeeID=3 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/10/1998 ShipVia=2 Freight=61.1400 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10989 CustomerID=QUEDE EmployeeID=2 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/2/1998 ShipVia=1 Freight=34.7600 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
This sample uses the DateTime's Year property to find Orders placed in 1997.
Public Sub LinqToSqlString16()
Dim q = From o In db.Orders _
Where o.OrderDate.Value.Year = 1997 _
Select o
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10400 CustomerID=EASTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipVia=3 Freight=83.9300 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10401 CustomerID=RATTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/10/1997 ShipVia=1 Freight=12.5100 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10402 CustomerID=ERNSH EmployeeID=8 OrderDate=1/2/1997 RequiredDate=2/13/1997 ShippedDate=1/10/1997 ShipVia=2 Freight=67.8800 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10403 CustomerID=ERNSH EmployeeID=4 OrderDate=1/3/1997 RequiredDate=1/31/1997 ShippedDate=1/9/1997 ShipVia=3 Freight=73.7900 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10404 CustomerID=MAGAA EmployeeID=2 OrderDate=1/3/1997 RequiredDate=1/31/1997 ShippedDate=1/8/1997 ShipVia=1 Freight=155.9700 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10405 CustomerID=LINOD EmployeeID=1 OrderDate=1/6/1997 RequiredDate=2/3/1997 ShippedDate=1/22/1997 ShipVia=1 Freight=34.8200 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10406 CustomerID=QUEEN EmployeeID=7 OrderDate=1/7/1997 RequiredDate=2/18/1997 ShippedDate=1/13/1997 ShipVia=1 Freight=108.0400 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10407 CustomerID=OTTIK EmployeeID=2 OrderDate=1/7/1997 RequiredDate=2/4/1997 ShippedDate=1/30/1997 ShipVia=2 Freight=91.4800 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10408 CustomerID=FOLIG EmployeeID=8 OrderDate=1/8/1997 RequiredDate=2/5/1997 ShippedDate=1/14/1997 ShipVia=1 Freight=11.2600 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10409 CustomerID=OCEAN EmployeeID=3 OrderDate=1/9/1997 RequiredDate=2/6/1997 ShippedDate=1/14/1997 ShipVia=1 Freight=29.8300 ShipName=Océano Atlántico Ltda. ShipAddress=Ing. Gustavo Moncada 8585 Piso 20-A ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10410 CustomerID=BOTTM EmployeeID=3 OrderDate=1/10/1997 RequiredDate=2/7/1997 ShippedDate=1/15/1997 ShipVia=3 Freight=2.4000 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10411 CustomerID=BOTTM EmployeeID=9 OrderDate=1/10/1997 RequiredDate=2/7/1997 ShippedDate=1/21/1997 ShipVia=3 Freight=23.6500 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10412 CustomerID=WARTH EmployeeID=8 OrderDate=1/13/1997 RequiredDate=2/10/1997 ShippedDate=1/15/1997 ShipVia=2 Freight=3.7700 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10413 CustomerID=LAMAI EmployeeID=3 OrderDate=1/14/1997 RequiredDate=2/11/1997 ShippedDate=1/16/1997 ShipVia=2 Freight=95.6600 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10414 CustomerID=FAMIA EmployeeID=2 OrderDate=1/14/1997 RequiredDate=2/11/1997 ShippedDate=1/17/1997 ShipVia=3 Freight=21.4800 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10415 CustomerID=HUNGC EmployeeID=3 OrderDate=1/15/1997 RequiredDate=2/12/1997 ShippedDate=1/24/1997 ShipVia=1 Freight=0.2000 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10416 CustomerID=WARTH EmployeeID=8 OrderDate=1/16/1997 RequiredDate=2/13/1997 ShippedDate=1/27/1997 ShipVia=3 Freight=22.7200 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10417 CustomerID=SIMOB EmployeeID=4 OrderDate=1/16/1997 RequiredDate=2/13/1997 ShippedDate=1/28/1997 ShipVia=3 Freight=70.2900 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10418 CustomerID=QUICK EmployeeID=4 OrderDate=1/17/1997 RequiredDate=2/14/1997 ShippedDate=1/24/1997 ShipVia=1 Freight=17.5500 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10419 CustomerID=RICSU EmployeeID=4 OrderDate=1/20/1997 RequiredDate=2/17/1997 ShippedDate=1/30/1997 ShipVia=2 Freight=137.3500 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10420 CustomerID=WELLI EmployeeID=3 OrderDate=1/21/1997 RequiredDate=2/18/1997 ShippedDate=1/27/1997 ShipVia=1 Freight=44.1200 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10421 CustomerID=QUEDE EmployeeID=8 OrderDate=1/21/1997 RequiredDate=3/4/1997 ShippedDate=1/27/1997 ShipVia=1 Freight=99.2300 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10422 CustomerID=FRANS EmployeeID=2 OrderDate=1/22/1997 RequiredDate=2/19/1997 ShippedDate=1/31/1997 ShipVia=1 Freight=3.0200 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10423 CustomerID=GOURL EmployeeID=6 OrderDate=1/23/1997 RequiredDate=2/6/1997 ShippedDate=2/24/1997 ShipVia=3 Freight=24.5000 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10424 CustomerID=MEREP EmployeeID=7 OrderDate=1/23/1997 RequiredDate=2/20/1997 ShippedDate=1/27/1997 ShipVia=2 Freight=370.6100 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10425 CustomerID=LAMAI EmployeeID=6 OrderDate=1/24/1997 RequiredDate=2/21/1997 ShippedDate=2/14/1997 ShipVia=2 Freight=7.9300 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10426 CustomerID=GALED EmployeeID=4 OrderDate=1/27/1997 RequiredDate=2/24/1997 ShippedDate=2/6/1997 ShipVia=1 Freight=18.6900 ShipName=Galería del gastronómo ShipAddress=Rambla de Cataluña, 23 ShipCity=Barcelona ShipRegion=null ShipPostalCode=8022 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10427 CustomerID=PICCO EmployeeID=4 OrderDate=1/27/1997 RequiredDate=2/24/1997 ShippedDate=3/3/1997 ShipVia=2 Freight=31.2900 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10428 CustomerID=REGGC EmployeeID=7 OrderDate=1/28/1997 RequiredDate=2/25/1997 ShippedDate=2/4/1997 ShipVia=1 Freight=11.0900 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10429 CustomerID=HUNGO EmployeeID=3 OrderDate=1/29/1997 RequiredDate=3/12/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=56.6300 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10430 CustomerID=ERNSH EmployeeID=4 OrderDate=1/30/1997 RequiredDate=2/13/1997 ShippedDate=2/3/1997 ShipVia=1 Freight=458.7800 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10431 CustomerID=BOTTM EmployeeID=4 OrderDate=1/30/1997 RequiredDate=2/13/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=44.1700 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10432 CustomerID=SPLIR EmployeeID=3 OrderDate=1/31/1997 RequiredDate=2/14/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=4.3400 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10433 CustomerID=PRINI EmployeeID=3 OrderDate=2/3/1997 RequiredDate=3/3/1997 ShippedDate=3/4/1997 ShipVia=3 Freight=73.8300 ShipName=Princesa Isabel Vinhos ShipAddress=Estrada da saúde n. 58 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1756 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10434 CustomerID=FOLKO EmployeeID=3 OrderDate=2/3/1997 RequiredDate=3/3/1997 ShippedDate=2/13/1997 ShipVia=2 Freight=17.9200 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10435 CustomerID=CONSH EmployeeID=8 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=9.2100 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10436 CustomerID=BLONP EmployeeID=3 OrderDate=2/5/1997 RequiredDate=3/5/1997 ShippedDate=2/11/1997 ShipVia=2 Freight=156.6600 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10437 CustomerID=WARTH EmployeeID=8 OrderDate=2/5/1997 RequiredDate=3/5/1997 ShippedDate=2/12/1997 ShipVia=1 Freight=19.9700 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10438 CustomerID=TOMSP EmployeeID=3 OrderDate=2/6/1997 RequiredDate=3/6/1997 ShippedDate=2/14/1997 ShipVia=2 Freight=8.2400 ShipName=Toms Spezialitäten ShipAddress=Luisenstr. 48 ShipCity=Münster ShipRegion=null ShipPostalCode=44087 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10439 CustomerID=MEREP EmployeeID=6 OrderDate=2/7/1997 RequiredDate=3/7/1997 ShippedDate=2/10/1997 ShipVia=3 Freight=4.0700 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10440 CustomerID=SAVEA EmployeeID=4 OrderDate=2/10/1997 RequiredDate=3/10/1997 ShippedDate=2/28/1997 ShipVia=2 Freight=86.5300 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10441 CustomerID=OLDWO EmployeeID=3 OrderDate=2/10/1997 RequiredDate=3/24/1997 ShippedDate=3/14/1997 ShipVia=2 Freight=73.0200 ShipName=Old World Delicatessen ShipAddress=2743 Bering St. ShipCity=Anchorage ShipRegion=AK ShipPostalCode=99508 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10442 CustomerID=ERNSH EmployeeID=3 OrderDate=2/11/1997 RequiredDate=3/11/1997 ShippedDate=2/18/1997 ShipVia=2 Freight=47.9400 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10443 CustomerID=REGGC EmployeeID=8 OrderDate=2/12/1997 RequiredDate=3/12/1997 ShippedDate=2/14/1997 ShipVia=1 Freight=13.9500 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10444 CustomerID=BERGS EmployeeID=3 OrderDate=2/12/1997 RequiredDate=3/12/1997 ShippedDate=2/21/1997 ShipVia=3 Freight=3.5000 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10445 CustomerID=BERGS EmployeeID=3 OrderDate=2/13/1997 RequiredDate=3/13/1997 ShippedDate=2/20/1997 ShipVia=1 Freight=9.3000 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10446 CustomerID=TOMSP EmployeeID=6 OrderDate=2/14/1997 RequiredDate=3/14/1997 ShippedDate=2/19/1997 ShipVia=1 Freight=14.6800 ShipName=Toms Spezialitäten ShipAddress=Luisenstr. 48 ShipCity=Münster ShipRegion=null ShipPostalCode=44087 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10447 CustomerID=RICAR EmployeeID=4 OrderDate=2/14/1997 RequiredDate=3/14/1997 ShippedDate=3/7/1997 ShipVia=2 Freight=68.6600 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10448 CustomerID=RANCH EmployeeID=4 OrderDate=2/17/1997 RequiredDate=3/17/1997 ShippedDate=2/24/1997 ShipVia=2 Freight=38.8200 ShipName=Rancho grande ShipAddress=Av. del Libertador 900 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10449 CustomerID=BLONP EmployeeID=3 OrderDate=2/18/1997 RequiredDate=3/18/1997 ShippedDate=2/27/1997 ShipVia=2 Freight=53.3000 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10450 CustomerID=VICTE EmployeeID=8 OrderDate=2/19/1997 RequiredDate=3/19/1997 ShippedDate=3/11/1997 ShipVia=2 Freight=7.2300 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10451 CustomerID=QUICK EmployeeID=4 OrderDate=2/19/1997 RequiredDate=3/5/1997 ShippedDate=3/12/1997 ShipVia=3 Freight=189.0900 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10452 CustomerID=SAVEA EmployeeID=8 OrderDate=2/20/1997 RequiredDate=3/20/1997 ShippedDate=2/26/1997 ShipVia=1 Freight=140.2600 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10453 CustomerID=AROUT EmployeeID=1 OrderDate=2/21/1997 RequiredDate=3/21/1997 ShippedDate=2/26/1997 ShipVia=2 Freight=25.3600 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10454 CustomerID=LAMAI EmployeeID=4 OrderDate=2/21/1997 RequiredDate=3/21/1997 ShippedDate=2/25/1997 ShipVia=3 Freight=2.7400 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10455 CustomerID=WARTH EmployeeID=8 OrderDate=2/24/1997 RequiredDate=4/7/1997 ShippedDate=3/3/1997 ShipVia=2 Freight=180.4500 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10456 CustomerID=KOENE EmployeeID=8 OrderDate=2/25/1997 RequiredDate=4/8/1997 ShippedDate=2/28/1997 ShipVia=2 Freight=8.1200 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10457 CustomerID=KOENE EmployeeID=2 OrderDate=2/25/1997 RequiredDate=3/25/1997 ShippedDate=3/3/1997 ShipVia=1 Freight=11.5700 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10458 CustomerID=SUPRD EmployeeID=7 OrderDate=2/26/1997 RequiredDate=3/26/1997 ShippedDate=3/4/1997 ShipVia=3 Freight=147.0600 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10459 CustomerID=VICTE EmployeeID=4 OrderDate=2/27/1997 RequiredDate=3/27/1997 ShippedDate=2/28/1997 ShipVia=2 Freight=25.0900 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10460 CustomerID=FOLKO EmployeeID=8 OrderDate=2/28/1997 RequiredDate=3/28/1997 ShippedDate=3/3/1997 ShipVia=1 Freight=16.2700 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10461 CustomerID=LILAS EmployeeID=1 OrderDate=2/28/1997 RequiredDate=3/28/1997 ShippedDate=3/5/1997 ShipVia=3 Freight=148.6100 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10462 CustomerID=CONSH EmployeeID=2 OrderDate=3/3/1997 RequiredDate=3/31/1997 ShippedDate=3/18/1997 ShipVia=1 Freight=6.1700 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10463 CustomerID=SUPRD EmployeeID=5 OrderDate=3/4/1997 RequiredDate=4/1/1997 ShippedDate=3/6/1997 ShipVia=3 Freight=14.7800 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10464 CustomerID=FURIB EmployeeID=4 OrderDate=3/4/1997 RequiredDate=4/1/1997 ShippedDate=3/14/1997 ShipVia=2 Freight=89.0000 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10465 CustomerID=VAFFE EmployeeID=1 OrderDate=3/5/1997 RequiredDate=4/2/1997 ShippedDate=3/14/1997 ShipVia=3 Freight=145.0400 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10466 CustomerID=COMMI EmployeeID=4 OrderDate=3/6/1997 RequiredDate=4/3/1997 ShippedDate=3/13/1997 ShipVia=1 Freight=11.9300 ShipName=Comércio Mineiro ShipAddress=Av. dos Lusíadas, 23 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05432-043 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10467 CustomerID=MAGAA EmployeeID=8 OrderDate=3/6/1997 RequiredDate=4/3/1997 ShippedDate=3/11/1997 ShipVia=2 Freight=4.9300 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10468 CustomerID=KOENE EmployeeID=3 OrderDate=3/7/1997 RequiredDate=4/4/1997 ShippedDate=3/12/1997 ShipVia=3 Freight=44.1200 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10469 CustomerID=WHITC EmployeeID=1 OrderDate=3/10/1997 RequiredDate=4/7/1997 ShippedDate=3/14/1997 ShipVia=1 Freight=60.1800 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10470 CustomerID=BONAP EmployeeID=4 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/14/1997 ShipVia=2 Freight=64.5600 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10471 CustomerID=BSBEV EmployeeID=2 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/18/1997 ShipVia=3 Freight=45.5900 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10472 CustomerID=SEVES EmployeeID=8 OrderDate=3/12/1997 RequiredDate=4/9/1997 ShippedDate=3/19/1997 ShipVia=1 Freight=4.2000 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10473 CustomerID=ISLAT EmployeeID=1 OrderDate=3/13/1997 RequiredDate=3/27/1997 ShippedDate=3/21/1997 ShipVia=3 Freight=16.3700 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10474 CustomerID=PERIC EmployeeID=5 OrderDate=3/13/1997 RequiredDate=4/10/1997 ShippedDate=3/21/1997 ShipVia=2 Freight=83.4900 ShipName=Pericles Comidas clásicas ShipAddress=Calle Dr. Jorge Cash 321 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10475 CustomerID=SUPRD EmployeeID=9 OrderDate=3/14/1997 RequiredDate=4/11/1997 ShippedDate=4/4/1997 ShipVia=1 Freight=68.5200 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10476 CustomerID=HILAA EmployeeID=8 OrderDate=3/17/1997 RequiredDate=4/14/1997 ShippedDate=3/24/1997 ShipVia=3 Freight=4.4100 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10477 CustomerID=PRINI EmployeeID=5 OrderDate=3/17/1997 RequiredDate=4/14/1997 ShippedDate=3/25/1997 ShipVia=2 Freight=13.0200 ShipName=Princesa Isabel Vinhos ShipAddress=Estrada da saúde n. 58 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1756 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10478 CustomerID=VICTE EmployeeID=2 OrderDate=3/18/1997 RequiredDate=4/1/1997 ShippedDate=3/26/1997 ShipVia=3 Freight=4.8100 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10479 CustomerID=RATTC EmployeeID=3 OrderDate=3/19/1997 RequiredDate=4/16/1997 ShippedDate=3/21/1997 ShipVia=3 Freight=708.9500 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10480 CustomerID=FOLIG EmployeeID=6 OrderDate=3/20/1997 RequiredDate=4/17/1997 ShippedDate=3/24/1997 ShipVia=2 Freight=1.3500 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10481 CustomerID=RICAR EmployeeID=8 OrderDate=3/20/1997 RequiredDate=4/17/1997 ShippedDate=3/25/1997 ShipVia=2 Freight=64.3300 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10482 CustomerID=LAZYK EmployeeID=1 OrderDate=3/21/1997 RequiredDate=4/18/1997 ShippedDate=4/10/1997 ShipVia=3 Freight=7.4800 ShipName=Lazy K Kountry Store ShipAddress=12 Orchestra Terrace ShipCity=Walla Walla ShipRegion=WA ShipPostalCode=99362 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10483 CustomerID=WHITC EmployeeID=7 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/25/1997 ShipVia=2 Freight=15.2800 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10484 CustomerID=BSBEV EmployeeID=3 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipVia=3 Freight=6.8800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10485 CustomerID=LINOD EmployeeID=4 OrderDate=3/25/1997 RequiredDate=4/8/1997 ShippedDate=3/31/1997 ShipVia=2 Freight=64.4500 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10486 CustomerID=HILAA EmployeeID=1 OrderDate=3/26/1997 RequiredDate=4/23/1997 ShippedDate=4/2/1997 ShipVia=2 Freight=30.5300 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10487 CustomerID=QUEEN EmployeeID=2 OrderDate=3/26/1997 RequiredDate=4/23/1997 ShippedDate=3/28/1997 ShipVia=2 Freight=71.0700 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10488 CustomerID=FRANK EmployeeID=8 OrderDate=3/27/1997 RequiredDate=4/24/1997 ShippedDate=4/2/1997 ShipVia=2 Freight=4.9300 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10489 CustomerID=PICCO EmployeeID=6 OrderDate=3/28/1997 RequiredDate=4/25/1997 ShippedDate=4/9/1997 ShipVia=2 Freight=5.2900 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10490 CustomerID=HILAA EmployeeID=7 OrderDate=3/31/1997 RequiredDate=4/28/1997 ShippedDate=4/3/1997 ShipVia=2 Freight=210.1900 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10491 CustomerID=FURIB EmployeeID=8 OrderDate=3/31/1997 RequiredDate=4/28/1997 ShippedDate=4/8/1997 ShipVia=3 Freight=16.9600 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10492 CustomerID=BOTTM EmployeeID=3 OrderDate=4/1/1997 RequiredDate=4/29/1997 ShippedDate=4/11/1997 ShipVia=1 Freight=62.8900 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10493 CustomerID=LAMAI EmployeeID=4 OrderDate=4/2/1997 RequiredDate=4/30/1997 ShippedDate=4/10/1997 ShipVia=3 Freight=10.6400 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10494 CustomerID=COMMI EmployeeID=4 OrderDate=4/2/1997 RequiredDate=4/30/1997 ShippedDate=4/9/1997 ShipVia=2 Freight=65.9900 ShipName=Comércio Mineiro ShipAddress=Av. dos Lusíadas, 23 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05432-043 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10495 CustomerID=LAUGB EmployeeID=3 OrderDate=4/3/1997 RequiredDate=5/1/1997 ShippedDate=4/11/1997 ShipVia=3 Freight=4.6500 ShipName=Laughing Bacchus Wine Cellars ShipAddress=2319 Elm St. ShipCity=Vancouver ShipRegion=BC ShipPostalCode=V3F 2K1 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10496 CustomerID=TRADH EmployeeID=7 OrderDate=4/4/1997 RequiredDate=5/2/1997 ShippedDate=4/7/1997 ShipVia=2 Freight=46.7700 ShipName=Tradiçao Hipermercados ShipAddress=Av. Inês de Castro, 414 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05634-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10497 CustomerID=LEHMS EmployeeID=7 OrderDate=4/4/1997 RequiredDate=5/2/1997 ShippedDate=4/7/1997 ShipVia=1 Freight=36.2100 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10498 CustomerID=HILAA EmployeeID=8 OrderDate=4/7/1997 RequiredDate=5/5/1997 ShippedDate=4/11/1997 ShipVia=2 Freight=29.7500 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10499 CustomerID=LILAS EmployeeID=4 OrderDate=4/8/1997 RequiredDate=5/6/1997 ShippedDate=4/16/1997 ShipVia=2 Freight=102.0200 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10500 CustomerID=LAMAI EmployeeID=6 OrderDate=4/9/1997 RequiredDate=5/7/1997 ShippedDate=4/17/1997 ShipVia=1 Freight=42.6800 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10501 CustomerID=BLAUS EmployeeID=9 OrderDate=4/9/1997 RequiredDate=5/7/1997 ShippedDate=4/16/1997 ShipVia=3 Freight=8.8500 ShipName=Blauer See Delikatessen ShipAddress=Forsterstr. 57 ShipCity=Mannheim ShipRegion=null ShipPostalCode=68306 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10502 CustomerID=PERIC EmployeeID=2 OrderDate=4/10/1997 RequiredDate=5/8/1997 ShippedDate=4/29/1997 ShipVia=1 Freight=69.3200 ShipName=Pericles Comidas clásicas ShipAddress=Calle Dr. Jorge Cash 321 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10503 CustomerID=HUNGO EmployeeID=6 OrderDate=4/11/1997 RequiredDate=5/9/1997 ShippedDate=4/16/1997 ShipVia=2 Freight=16.7400 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10504 CustomerID=WHITC EmployeeID=4 OrderDate=4/11/1997 RequiredDate=5/9/1997 ShippedDate=4/18/1997 ShipVia=3 Freight=59.1300 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10505 CustomerID=MEREP EmployeeID=3 OrderDate=4/14/1997 RequiredDate=5/12/1997 ShippedDate=4/21/1997 ShipVia=3 Freight=7.1300 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10506 CustomerID=KOENE EmployeeID=9 OrderDate=4/15/1997 RequiredDate=5/13/1997 ShippedDate=5/2/1997 ShipVia=2 Freight=21.1900 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10507 CustomerID=ANTON EmployeeID=7 OrderDate=4/15/1997 RequiredDate=5/13/1997 ShippedDate=4/22/1997 ShipVia=1 Freight=47.4500 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10508 CustomerID=OTTIK EmployeeID=1 OrderDate=4/16/1997 RequiredDate=5/14/1997 ShippedDate=5/13/1997 ShipVia=2 Freight=4.9900 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10509 CustomerID=BLAUS EmployeeID=4 OrderDate=4/17/1997 RequiredDate=5/15/1997 ShippedDate=4/29/1997 ShipVia=1 Freight=0.1500 ShipName=Blauer See Delikatessen ShipAddress=Forsterstr. 57 ShipCity=Mannheim ShipRegion=null ShipPostalCode=68306 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10510 CustomerID=SAVEA EmployeeID=6 OrderDate=4/18/1997 RequiredDate=5/16/1997 ShippedDate=4/28/1997 ShipVia=3 Freight=367.6300 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10511 CustomerID=BONAP EmployeeID=4 OrderDate=4/18/1997 RequiredDate=5/16/1997 ShippedDate=4/21/1997 ShipVia=3 Freight=350.6400 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10512 CustomerID=FAMIA EmployeeID=7 OrderDate=4/21/1997 RequiredDate=5/19/1997 ShippedDate=4/24/1997 ShipVia=2 Freight=3.5300 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10513 CustomerID=WANDK EmployeeID=7 OrderDate=4/22/1997 RequiredDate=6/3/1997 ShippedDate=4/28/1997 ShipVia=1 Freight=105.6500 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10514 CustomerID=ERNSH EmployeeID=3 OrderDate=4/22/1997 RequiredDate=5/20/1997 ShippedDate=5/16/1997 ShipVia=2 Freight=789.9500 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10515 CustomerID=QUICK EmployeeID=2 OrderDate=4/23/1997 RequiredDate=5/7/1997 ShippedDate=5/23/1997 ShipVia=1 Freight=204.4700 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10516 CustomerID=HUNGO EmployeeID=2 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=5/1/1997 ShipVia=3 Freight=62.7800 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10517 CustomerID=NORTS EmployeeID=3 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipVia=3 Freight=32.0700 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10518 CustomerID=TORTU EmployeeID=4 OrderDate=4/25/1997 RequiredDate=5/9/1997 ShippedDate=5/5/1997 ShipVia=2 Freight=218.1500 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10519 CustomerID=CHOPS EmployeeID=6 OrderDate=4/28/1997 RequiredDate=5/26/1997 ShippedDate=5/1/1997 ShipVia=3 Freight=91.7600 ShipName=Chop-suey Chinese ShipAddress=Hauptstr. 31 ShipCity=Bern ShipRegion=null ShipPostalCode=3012 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10520 CustomerID=SANTG EmployeeID=7 OrderDate=4/29/1997 RequiredDate=5/27/1997 ShippedDate=5/1/1997 ShipVia=1 Freight=13.3700 ShipName=Santé Gourmet ShipAddress=Erling Skakkes gate 78 ShipCity=Stavern ShipRegion=null ShipPostalCode=4110 ShipCountry=Norway Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10521 CustomerID=CACTU EmployeeID=8 OrderDate=4/29/1997 RequiredDate=5/27/1997 ShippedDate=5/2/1997 ShipVia=2 Freight=17.2200 ShipName=Cactus Comidas para llevar ShipAddress=Cerrito 333 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10522 CustomerID=LEHMS EmployeeID=4 OrderDate=4/30/1997 RequiredDate=5/28/1997 ShippedDate=5/6/1997 ShipVia=1 Freight=45.3300 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10523 CustomerID=SEVES EmployeeID=7 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipVia=2 Freight=77.6300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10524 CustomerID=BERGS EmployeeID=1 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/7/1997 ShipVia=2 Freight=244.7900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10525 CustomerID=BONAP EmployeeID=1 OrderDate=5/2/1997 RequiredDate=5/30/1997 ShippedDate=5/23/1997 ShipVia=2 Freight=11.0600 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10526 CustomerID=WARTH EmployeeID=4 OrderDate=5/5/1997 RequiredDate=6/2/1997 ShippedDate=5/15/1997 ShipVia=2 Freight=58.5900 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10527 CustomerID=QUICK EmployeeID=7 OrderDate=5/5/1997 RequiredDate=6/2/1997 ShippedDate=5/7/1997 ShipVia=1 Freight=41.9000 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10528 CustomerID=GREAL EmployeeID=6 OrderDate=5/6/1997 RequiredDate=5/20/1997 ShippedDate=5/9/1997 ShipVia=2 Freight=3.3500 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10529 CustomerID=MAISD EmployeeID=5 OrderDate=5/7/1997 RequiredDate=6/4/1997 ShippedDate=5/9/1997 ShipVia=2 Freight=66.6900 ShipName=Maison Dewey ShipAddress=Rue Joseph-Bens 532 ShipCity=Bruxelles ShipRegion=null ShipPostalCode=B-1180 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10530 CustomerID=PICCO EmployeeID=3 OrderDate=5/8/1997 RequiredDate=6/5/1997 ShippedDate=5/12/1997 ShipVia=2 Freight=339.2200 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10531 CustomerID=OCEAN EmployeeID=7 OrderDate=5/8/1997 RequiredDate=6/5/1997 ShippedDate=5/19/1997 ShipVia=1 Freight=8.1200 ShipName=Océano Atlántico Ltda. ShipAddress=Ing. Gustavo Moncada 8585 Piso 20-A ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10532 CustomerID=EASTC EmployeeID=7 OrderDate=5/9/1997 RequiredDate=6/6/1997 ShippedDate=5/12/1997 ShipVia=3 Freight=74.4600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10533 CustomerID=FOLKO EmployeeID=8 OrderDate=5/12/1997 RequiredDate=6/9/1997 ShippedDate=5/22/1997 ShipVia=1 Freight=188.0400 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10534 CustomerID=LEHMS EmployeeID=8 OrderDate=5/12/1997 RequiredDate=6/9/1997 ShippedDate=5/14/1997 ShipVia=2 Freight=27.9400 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10535 CustomerID=ANTON EmployeeID=4 OrderDate=5/13/1997 RequiredDate=6/10/1997 ShippedDate=5/21/1997 ShipVia=1 Freight=15.6400 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10536 CustomerID=LEHMS EmployeeID=3 OrderDate=5/14/1997 RequiredDate=6/11/1997 ShippedDate=6/6/1997 ShipVia=2 Freight=58.8800 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10537 CustomerID=RICSU EmployeeID=1 OrderDate=5/14/1997 RequiredDate=5/28/1997 ShippedDate=5/19/1997 ShipVia=1 Freight=78.8500 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10538 CustomerID=BSBEV EmployeeID=9 OrderDate=5/15/1997 RequiredDate=6/12/1997 ShippedDate=5/16/1997 ShipVia=3 Freight=4.8700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10539 CustomerID=BSBEV EmployeeID=6 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipVia=3 Freight=12.3600 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10540 CustomerID=QUICK EmployeeID=3 OrderDate=5/19/1997 RequiredDate=6/16/1997 ShippedDate=6/13/1997 ShipVia=3 Freight=1007.6400 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10541 CustomerID=HANAR EmployeeID=2 OrderDate=5/19/1997 RequiredDate=6/16/1997 ShippedDate=5/29/1997 ShipVia=1 Freight=68.6500 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10542 CustomerID=KOENE EmployeeID=1 OrderDate=5/20/1997 RequiredDate=6/17/1997 ShippedDate=5/26/1997 ShipVia=3 Freight=10.9500 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10543 CustomerID=LILAS EmployeeID=8 OrderDate=5/21/1997 RequiredDate=6/18/1997 ShippedDate=5/23/1997 ShipVia=2 Freight=48.1700 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10544 CustomerID=LONEP EmployeeID=4 OrderDate=5/21/1997 RequiredDate=6/18/1997 ShippedDate=5/30/1997 ShipVia=1 Freight=24.9100 ShipName=Lonesome Pine Restaurant ShipAddress=89 Chiaroscuro Rd. ShipCity=Portland ShipRegion=OR ShipPostalCode=97219 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10545 CustomerID=LAZYK EmployeeID=8 OrderDate=5/22/1997 RequiredDate=6/19/1997 ShippedDate=6/26/1997 ShipVia=2 Freight=11.9200 ShipName=Lazy K Kountry Store ShipAddress=12 Orchestra Terrace ShipCity=Walla Walla ShipRegion=WA ShipPostalCode=99362 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10546 CustomerID=VICTE EmployeeID=1 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=5/27/1997 ShipVia=3 Freight=194.7200 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10547 CustomerID=SEVES EmployeeID=3 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=6/2/1997 ShipVia=2 Freight=178.4300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10548 CustomerID=TOMSP EmployeeID=3 OrderDate=5/26/1997 RequiredDate=6/23/1997 ShippedDate=6/2/1997 ShipVia=2 Freight=1.4300 ShipName=Toms Spezialitäten ShipAddress=Luisenstr. 48 ShipCity=Münster ShipRegion=null ShipPostalCode=44087 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10549 CustomerID=QUICK EmployeeID=5 OrderDate=5/27/1997 RequiredDate=6/10/1997 ShippedDate=5/30/1997 ShipVia=1 Freight=171.2400 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10550 CustomerID=GODOS EmployeeID=7 OrderDate=5/28/1997 RequiredDate=6/25/1997 ShippedDate=6/6/1997 ShipVia=3 Freight=4.3200 ShipName=Godos Cocina Típica ShipAddress=C/ Romero, 33 ShipCity=Sevilla ShipRegion=null ShipPostalCode=41101 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10551 CustomerID=FURIB EmployeeID=4 OrderDate=5/28/1997 RequiredDate=7/9/1997 ShippedDate=6/6/1997 ShipVia=3 Freight=72.9500 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10552 CustomerID=HILAA EmployeeID=2 OrderDate=5/29/1997 RequiredDate=6/26/1997 ShippedDate=6/5/1997 ShipVia=1 Freight=83.2200 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10553 CustomerID=WARTH EmployeeID=2 OrderDate=5/30/1997 RequiredDate=6/27/1997 ShippedDate=6/3/1997 ShipVia=2 Freight=149.4900 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10554 CustomerID=OTTIK EmployeeID=4 OrderDate=5/30/1997 RequiredDate=6/27/1997 ShippedDate=6/5/1997 ShipVia=3 Freight=120.9700 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10555 CustomerID=SAVEA EmployeeID=6 OrderDate=6/2/1997 RequiredDate=6/30/1997 ShippedDate=6/4/1997 ShipVia=3 Freight=252.4900 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10556 CustomerID=SIMOB EmployeeID=2 OrderDate=6/3/1997 RequiredDate=7/15/1997 ShippedDate=6/13/1997 ShipVia=1 Freight=9.8000 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10557 CustomerID=LEHMS EmployeeID=9 OrderDate=6/3/1997 RequiredDate=6/17/1997 ShippedDate=6/6/1997 ShipVia=2 Freight=96.7200 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10558 CustomerID=AROUT EmployeeID=1 OrderDate=6/4/1997 RequiredDate=7/2/1997 ShippedDate=6/10/1997 ShipVia=2 Freight=72.9700 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10559 CustomerID=BLONP EmployeeID=6 OrderDate=6/5/1997 RequiredDate=7/3/1997 ShippedDate=6/13/1997 ShipVia=1 Freight=8.0500 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10560 CustomerID=FRANK EmployeeID=8 OrderDate=6/6/1997 RequiredDate=7/4/1997 ShippedDate=6/9/1997 ShipVia=1 Freight=36.6500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10561 CustomerID=FOLKO EmployeeID=2 OrderDate=6/6/1997 RequiredDate=7/4/1997 ShippedDate=6/9/1997 ShipVia=2 Freight=242.2100 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10562 CustomerID=REGGC EmployeeID=1 OrderDate=6/9/1997 RequiredDate=7/7/1997 ShippedDate=6/12/1997 ShipVia=1 Freight=22.9500 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10563 CustomerID=RICAR EmployeeID=2 OrderDate=6/10/1997 RequiredDate=7/22/1997 ShippedDate=6/24/1997 ShipVia=2 Freight=60.4300 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10564 CustomerID=RATTC EmployeeID=4 OrderDate=6/10/1997 RequiredDate=7/8/1997 ShippedDate=6/16/1997 ShipVia=3 Freight=13.7500 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10565 CustomerID=MEREP EmployeeID=8 OrderDate=6/11/1997 RequiredDate=7/9/1997 ShippedDate=6/18/1997 ShipVia=2 Freight=7.1500 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10566 CustomerID=BLONP EmployeeID=9 OrderDate=6/12/1997 RequiredDate=7/10/1997 ShippedDate=6/18/1997 ShipVia=1 Freight=88.4000 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10567 CustomerID=HUNGO EmployeeID=1 OrderDate=6/12/1997 RequiredDate=7/10/1997 ShippedDate=6/17/1997 ShipVia=1 Freight=33.9700 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10568 CustomerID=GALED EmployeeID=3 OrderDate=6/13/1997 RequiredDate=7/11/1997 ShippedDate=7/9/1997 ShipVia=3 Freight=6.5400 ShipName=Galería del gastronómo ShipAddress=Rambla de Cataluña, 23 ShipCity=Barcelona ShipRegion=null ShipPostalCode=8022 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10569 CustomerID=RATTC EmployeeID=5 OrderDate=6/16/1997 RequiredDate=7/14/1997 ShippedDate=7/11/1997 ShipVia=1 Freight=58.9800 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10570 CustomerID=MEREP EmployeeID=3 OrderDate=6/17/1997 RequiredDate=7/15/1997 ShippedDate=6/19/1997 ShipVia=3 Freight=188.9900 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10571 CustomerID=ERNSH EmployeeID=8 OrderDate=6/17/1997 RequiredDate=7/29/1997 ShippedDate=7/4/1997 ShipVia=3 Freight=26.0600 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10572 CustomerID=BERGS EmployeeID=3 OrderDate=6/18/1997 RequiredDate=7/16/1997 ShippedDate=6/25/1997 ShipVia=2 Freight=116.4300 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10573 CustomerID=ANTON EmployeeID=7 OrderDate=6/19/1997 RequiredDate=7/17/1997 ShippedDate=6/20/1997 ShipVia=3 Freight=84.8400 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10574 CustomerID=TRAIH EmployeeID=4 OrderDate=6/19/1997 RequiredDate=7/17/1997 ShippedDate=6/30/1997 ShipVia=2 Freight=37.6000 ShipName=Trail's Head Gourmet Provisioners ShipAddress=722 DaVinci Blvd. ShipCity=Kirkland ShipRegion=WA ShipPostalCode=98034 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10575 CustomerID=MORGK EmployeeID=5 OrderDate=6/20/1997 RequiredDate=7/4/1997 ShippedDate=6/30/1997 ShipVia=1 Freight=127.3400 ShipName=Morgenstern Gesundkost ShipAddress=Heerstr. 22 ShipCity=Leipzig ShipRegion=null ShipPostalCode=04179 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10576 CustomerID=TORTU EmployeeID=3 OrderDate=6/23/1997 RequiredDate=7/7/1997 ShippedDate=6/30/1997 ShipVia=3 Freight=18.5600 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10577 CustomerID=TRAIH EmployeeID=9 OrderDate=6/23/1997 RequiredDate=8/4/1997 ShippedDate=6/30/1997 ShipVia=2 Freight=25.4100 ShipName=Trail's Head Gourmet Provisioners ShipAddress=722 DaVinci Blvd. ShipCity=Kirkland ShipRegion=WA ShipPostalCode=98034 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10578 CustomerID=BSBEV EmployeeID=4 OrderDate=6/24/1997 RequiredDate=7/22/1997 ShippedDate=7/25/1997 ShipVia=3 Freight=29.6000 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10579 CustomerID=LETSS EmployeeID=1 OrderDate=6/25/1997 RequiredDate=7/23/1997 ShippedDate=7/4/1997 ShipVia=2 Freight=13.7300 ShipName=Let's Stop N Shop ShipAddress=87 Polk St. Suite 5 ShipCity=San Francisco ShipRegion=CA ShipPostalCode=94117 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10580 CustomerID=OTTIK EmployeeID=4 OrderDate=6/26/1997 RequiredDate=7/24/1997 ShippedDate=7/1/1997 ShipVia=3 Freight=75.8900 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10581 CustomerID=FAMIA EmployeeID=3 OrderDate=6/26/1997 RequiredDate=7/24/1997 ShippedDate=7/2/1997 ShipVia=1 Freight=3.0100 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10582 CustomerID=BLAUS EmployeeID=3 OrderDate=6/27/1997 RequiredDate=7/25/1997 ShippedDate=7/14/1997 ShipVia=2 Freight=27.7100 ShipName=Blauer See Delikatessen ShipAddress=Forsterstr. 57 ShipCity=Mannheim ShipRegion=null ShipPostalCode=68306 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10583 CustomerID=WARTH EmployeeID=2 OrderDate=6/30/1997 RequiredDate=7/28/1997 ShippedDate=7/4/1997 ShipVia=2 Freight=7.2800 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10584 CustomerID=BLONP EmployeeID=4 OrderDate=6/30/1997 RequiredDate=7/28/1997 ShippedDate=7/4/1997 ShipVia=1 Freight=59.1400 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10585 CustomerID=WELLI EmployeeID=7 OrderDate=7/1/1997 RequiredDate=7/29/1997 ShippedDate=7/10/1997 ShipVia=1 Freight=13.4100 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10586 CustomerID=REGGC EmployeeID=9 OrderDate=7/2/1997 RequiredDate=7/30/1997 ShippedDate=7/9/1997 ShipVia=1 Freight=0.4800 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10587 CustomerID=QUEDE EmployeeID=1 OrderDate=7/2/1997 RequiredDate=7/30/1997 ShippedDate=7/9/1997 ShipVia=1 Freight=62.5200 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10588 CustomerID=QUICK EmployeeID=2 OrderDate=7/3/1997 RequiredDate=7/31/1997 ShippedDate=7/10/1997 ShipVia=3 Freight=194.6700 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10589 CustomerID=GREAL EmployeeID=8 OrderDate=7/4/1997 RequiredDate=8/1/1997 ShippedDate=7/14/1997 ShipVia=2 Freight=4.4200 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10590 CustomerID=MEREP EmployeeID=4 OrderDate=7/7/1997 RequiredDate=8/4/1997 ShippedDate=7/14/1997 ShipVia=3 Freight=44.7700 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10591 CustomerID=VAFFE EmployeeID=1 OrderDate=7/7/1997 RequiredDate=7/21/1997 ShippedDate=7/16/1997 ShipVia=1 Freight=55.9200 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10592 CustomerID=LEHMS EmployeeID=3 OrderDate=7/8/1997 RequiredDate=8/5/1997 ShippedDate=7/16/1997 ShipVia=1 Freight=32.1000 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10593 CustomerID=LEHMS EmployeeID=7 OrderDate=7/9/1997 RequiredDate=8/6/1997 ShippedDate=8/13/1997 ShipVia=2 Freight=174.2000 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10594 CustomerID=OLDWO EmployeeID=3 OrderDate=7/9/1997 RequiredDate=8/6/1997 ShippedDate=7/16/1997 ShipVia=2 Freight=5.2400 ShipName=Old World Delicatessen ShipAddress=2743 Bering St. ShipCity=Anchorage ShipRegion=AK ShipPostalCode=99508 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10595 CustomerID=ERNSH EmployeeID=2 OrderDate=7/10/1997 RequiredDate=8/7/1997 ShippedDate=7/14/1997 ShipVia=1 Freight=96.7800 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10596 CustomerID=WHITC EmployeeID=8 OrderDate=7/11/1997 RequiredDate=8/8/1997 ShippedDate=8/12/1997 ShipVia=1 Freight=16.3400 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10597 CustomerID=PICCO EmployeeID=7 OrderDate=7/11/1997 RequiredDate=8/8/1997 ShippedDate=7/18/1997 ShipVia=3 Freight=35.1200 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10598 CustomerID=RATTC EmployeeID=1 OrderDate=7/14/1997 RequiredDate=8/11/1997 ShippedDate=7/18/1997 ShipVia=3 Freight=44.4200 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10599 CustomerID=BSBEV EmployeeID=6 OrderDate=7/15/1997 RequiredDate=8/26/1997 ShippedDate=7/21/1997 ShipVia=3 Freight=29.9800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10600 CustomerID=HUNGC EmployeeID=4 OrderDate=7/16/1997 RequiredDate=8/13/1997 ShippedDate=7/21/1997 ShipVia=1 Freight=45.1300 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10601 CustomerID=HILAA EmployeeID=7 OrderDate=7/16/1997 RequiredDate=8/27/1997 ShippedDate=7/22/1997 ShipVia=1 Freight=58.3000 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10602 CustomerID=VAFFE EmployeeID=8 OrderDate=7/17/1997 RequiredDate=8/14/1997 ShippedDate=7/22/1997 ShipVia=2 Freight=2.9200 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10603 CustomerID=SAVEA EmployeeID=8 OrderDate=7/18/1997 RequiredDate=8/15/1997 ShippedDate=8/8/1997 ShipVia=2 Freight=48.7700 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10604 CustomerID=FURIB EmployeeID=1 OrderDate=7/18/1997 RequiredDate=8/15/1997 ShippedDate=7/29/1997 ShipVia=1 Freight=7.4600 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10605 CustomerID=MEREP EmployeeID=1 OrderDate=7/21/1997 RequiredDate=8/18/1997 ShippedDate=7/29/1997 ShipVia=2 Freight=379.1300 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10606 CustomerID=TRADH EmployeeID=4 OrderDate=7/22/1997 RequiredDate=8/19/1997 ShippedDate=7/31/1997 ShipVia=3 Freight=79.4000 ShipName=Tradiçao Hipermercados ShipAddress=Av. Inês de Castro, 414 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05634-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10607 CustomerID=SAVEA EmployeeID=5 OrderDate=7/22/1997 RequiredDate=8/19/1997 ShippedDate=7/25/1997 ShipVia=1 Freight=200.2400 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10608 CustomerID=TOMSP EmployeeID=4 OrderDate=7/23/1997 RequiredDate=8/20/1997 ShippedDate=8/1/1997 ShipVia=2 Freight=27.7900 ShipName=Toms Spezialitäten ShipAddress=Luisenstr. 48 ShipCity=Münster ShipRegion=null ShipPostalCode=44087 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10609 CustomerID=DUMON EmployeeID=7 OrderDate=7/24/1997 RequiredDate=8/21/1997 ShippedDate=7/30/1997 ShipVia=2 Freight=1.8500 ShipName=Du monde entier ShipAddress=67, rue des Cinquante Otages ShipCity=Nantes ShipRegion=null ShipPostalCode=44000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10610 CustomerID=LAMAI EmployeeID=8 OrderDate=7/25/1997 RequiredDate=8/22/1997 ShippedDate=8/6/1997 ShipVia=1 Freight=26.7800 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10611 CustomerID=WOLZA EmployeeID=6 OrderDate=7/25/1997 RequiredDate=8/22/1997 ShippedDate=8/1/1997 ShipVia=2 Freight=80.6500 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10612 CustomerID=SAVEA EmployeeID=1 OrderDate=7/28/1997 RequiredDate=8/25/1997 ShippedDate=8/1/1997 ShipVia=2 Freight=544.0800 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10613 CustomerID=HILAA EmployeeID=4 OrderDate=7/29/1997 RequiredDate=8/26/1997 ShippedDate=8/1/1997 ShipVia=2 Freight=8.1100 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10614 CustomerID=BLAUS EmployeeID=8 OrderDate=7/29/1997 RequiredDate=8/26/1997 ShippedDate=8/1/1997 ShipVia=3 Freight=1.9300 ShipName=Blauer See Delikatessen ShipAddress=Forsterstr. 57 ShipCity=Mannheim ShipRegion=null ShipPostalCode=68306 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10615 CustomerID=WILMK EmployeeID=2 OrderDate=7/30/1997 RequiredDate=8/27/1997 ShippedDate=8/6/1997 ShipVia=3 Freight=0.7500 ShipName=Wilman Kala ShipAddress=Keskuskatu 45 ShipCity=Helsinki ShipRegion=null ShipPostalCode=21240 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10616 CustomerID=GREAL EmployeeID=1 OrderDate=7/31/1997 RequiredDate=8/28/1997 ShippedDate=8/5/1997 ShipVia=2 Freight=116.5300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10617 CustomerID=GREAL EmployeeID=4 OrderDate=7/31/1997 RequiredDate=8/28/1997 ShippedDate=8/4/1997 ShipVia=2 Freight=18.5300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10618 CustomerID=MEREP EmployeeID=1 OrderDate=8/1/1997 RequiredDate=9/12/1997 ShippedDate=8/8/1997 ShipVia=1 Freight=154.6800 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10619 CustomerID=MEREP EmployeeID=3 OrderDate=8/4/1997 RequiredDate=9/1/1997 ShippedDate=8/7/1997 ShipVia=3 Freight=91.0500 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10620 CustomerID=LAUGB EmployeeID=2 OrderDate=8/5/1997 RequiredDate=9/2/1997 ShippedDate=8/14/1997 ShipVia=3 Freight=0.9400 ShipName=Laughing Bacchus Wine Cellars ShipAddress=2319 Elm St. ShipCity=Vancouver ShipRegion=BC ShipPostalCode=V3F 2K1 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10621 CustomerID=ISLAT EmployeeID=4 OrderDate=8/5/1997 RequiredDate=9/2/1997 ShippedDate=8/11/1997 ShipVia=2 Freight=23.7300 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10622 CustomerID=RICAR EmployeeID=4 OrderDate=8/6/1997 RequiredDate=9/3/1997 ShippedDate=8/11/1997 ShipVia=3 Freight=50.9700 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10623 CustomerID=FRANK EmployeeID=8 OrderDate=8/7/1997 RequiredDate=9/4/1997 ShippedDate=8/12/1997 ShipVia=2 Freight=97.1800 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10624 CustomerID=THECR EmployeeID=4 OrderDate=8/7/1997 RequiredDate=9/4/1997 ShippedDate=8/19/1997 ShipVia=2 Freight=94.8000 ShipName=The Cracker Box ShipAddress=55 Grizzly Peak Rd. ShipCity=Butte ShipRegion=MT ShipPostalCode=59801 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10625 CustomerID=ANATR EmployeeID=3 OrderDate=8/8/1997 RequiredDate=9/5/1997 ShippedDate=8/14/1997 ShipVia=1 Freight=43.9000 ShipName=Ana Trujillo Emparedados y helados ShipAddress=Avda. de la Constitución 2222 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05021 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10626 CustomerID=BERGS EmployeeID=1 OrderDate=8/11/1997 RequiredDate=9/8/1997 ShippedDate=8/20/1997 ShipVia=2 Freight=138.6900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10627 CustomerID=SAVEA EmployeeID=8 OrderDate=8/11/1997 RequiredDate=9/22/1997 ShippedDate=8/21/1997 ShipVia=3 Freight=107.4600 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10628 CustomerID=BLONP EmployeeID=4 OrderDate=8/12/1997 RequiredDate=9/9/1997 ShippedDate=8/20/1997 ShipVia=3 Freight=30.3600 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10629 CustomerID=GODOS EmployeeID=4 OrderDate=8/12/1997 RequiredDate=9/9/1997 ShippedDate=8/20/1997 ShipVia=3 Freight=85.4600 ShipName=Godos Cocina Típica ShipAddress=C/ Romero, 33 ShipCity=Sevilla ShipRegion=null ShipPostalCode=41101 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10630 CustomerID=KOENE EmployeeID=1 OrderDate=8/13/1997 RequiredDate=9/10/1997 ShippedDate=8/19/1997 ShipVia=2 Freight=32.3500 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10631 CustomerID=LAMAI EmployeeID=8 OrderDate=8/14/1997 RequiredDate=9/11/1997 ShippedDate=8/15/1997 ShipVia=1 Freight=0.8700 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10632 CustomerID=WANDK EmployeeID=8 OrderDate=8/14/1997 RequiredDate=9/11/1997 ShippedDate=8/19/1997 ShipVia=1 Freight=41.3800 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10633 CustomerID=ERNSH EmployeeID=7 OrderDate=8/15/1997 RequiredDate=9/12/1997 ShippedDate=8/18/1997 ShipVia=3 Freight=477.9000 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10634 CustomerID=FOLIG EmployeeID=4 OrderDate=8/15/1997 RequiredDate=9/12/1997 ShippedDate=8/21/1997 ShipVia=3 Freight=487.3800 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10635 CustomerID=MAGAA EmployeeID=8 OrderDate=8/18/1997 RequiredDate=9/15/1997 ShippedDate=8/21/1997 ShipVia=3 Freight=47.4600 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10636 CustomerID=WARTH EmployeeID=4 OrderDate=8/19/1997 RequiredDate=9/16/1997 ShippedDate=8/26/1997 ShipVia=1 Freight=1.1500 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10637 CustomerID=QUEEN EmployeeID=6 OrderDate=8/19/1997 RequiredDate=9/16/1997 ShippedDate=8/26/1997 ShipVia=1 Freight=201.2900 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10638 CustomerID=LINOD EmployeeID=3 OrderDate=8/20/1997 RequiredDate=9/17/1997 ShippedDate=9/1/1997 ShipVia=1 Freight=158.4400 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10639 CustomerID=SANTG EmployeeID=7 OrderDate=8/20/1997 RequiredDate=9/17/1997 ShippedDate=8/27/1997 ShipVia=3 Freight=38.6400 ShipName=Santé Gourmet ShipAddress=Erling Skakkes gate 78 ShipCity=Stavern ShipRegion=null ShipPostalCode=4110 ShipCountry=Norway Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10640 CustomerID=WANDK EmployeeID=4 OrderDate=8/21/1997 RequiredDate=9/18/1997 ShippedDate=8/28/1997 ShipVia=1 Freight=23.5500 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10641 CustomerID=HILAA EmployeeID=4 OrderDate=8/22/1997 RequiredDate=9/19/1997 ShippedDate=8/26/1997 ShipVia=2 Freight=179.6100 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10642 CustomerID=SIMOB EmployeeID=7 OrderDate=8/22/1997 RequiredDate=9/19/1997 ShippedDate=9/5/1997 ShipVia=3 Freight=41.8900 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10643 CustomerID=ALFKI EmployeeID=6 OrderDate=8/25/1997 RequiredDate=9/22/1997 ShippedDate=9/2/1997 ShipVia=1 Freight=1.2100 ShipName=Alfreds Futterkiste ShipAddress=Obere Str. 57 ShipCity=Berlin ShipRegion=null ShipPostalCode=12209 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10644 CustomerID=WELLI EmployeeID=3 OrderDate=8/25/1997 RequiredDate=9/22/1997 ShippedDate=9/1/1997 ShipVia=2 Freight=0.1400 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10645 CustomerID=HANAR EmployeeID=4 OrderDate=8/26/1997 RequiredDate=9/23/1997 ShippedDate=9/2/1997 ShipVia=1 Freight=12.4100 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10646 CustomerID=HUNGO EmployeeID=9 OrderDate=8/27/1997 RequiredDate=10/8/1997 ShippedDate=9/3/1997 ShipVia=3 Freight=142.3300 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10647 CustomerID=QUEDE EmployeeID=4 OrderDate=8/27/1997 RequiredDate=9/10/1997 ShippedDate=9/3/1997 ShipVia=2 Freight=45.5400 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10648 CustomerID=RICAR EmployeeID=5 OrderDate=8/28/1997 RequiredDate=10/9/1997 ShippedDate=9/9/1997 ShipVia=2 Freight=14.2500 ShipName=Ricardo Adocicados ShipAddress=Av. Copacabana, 267 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-890 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10649 CustomerID=MAISD EmployeeID=5 OrderDate=8/28/1997 RequiredDate=9/25/1997 ShippedDate=8/29/1997 ShipVia=3 Freight=6.2000 ShipName=Maison Dewey ShipAddress=Rue Joseph-Bens 532 ShipCity=Bruxelles ShipRegion=null ShipPostalCode=B-1180 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10650 CustomerID=FAMIA EmployeeID=5 OrderDate=8/29/1997 RequiredDate=9/26/1997 ShippedDate=9/3/1997 ShipVia=3 Freight=176.8100 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10651 CustomerID=WANDK EmployeeID=8 OrderDate=9/1/1997 RequiredDate=9/29/1997 ShippedDate=9/11/1997 ShipVia=2 Freight=20.6000 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10652 CustomerID=GOURL EmployeeID=4 OrderDate=9/1/1997 RequiredDate=9/29/1997 ShippedDate=9/8/1997 ShipVia=2 Freight=7.1400 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10653 CustomerID=FRANK EmployeeID=1 OrderDate=9/2/1997 RequiredDate=9/30/1997 ShippedDate=9/19/1997 ShipVia=1 Freight=93.2500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10654 CustomerID=BERGS EmployeeID=5 OrderDate=9/2/1997 RequiredDate=9/30/1997 ShippedDate=9/11/1997 ShipVia=1 Freight=55.2600 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10655 CustomerID=REGGC EmployeeID=1 OrderDate=9/3/1997 RequiredDate=10/1/1997 ShippedDate=9/11/1997 ShipVia=2 Freight=4.4100 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10656 CustomerID=GREAL EmployeeID=6 OrderDate=9/4/1997 RequiredDate=10/2/1997 ShippedDate=9/10/1997 ShipVia=1 Freight=57.1500 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10657 CustomerID=SAVEA EmployeeID=2 OrderDate=9/4/1997 RequiredDate=10/2/1997 ShippedDate=9/15/1997 ShipVia=2 Freight=352.6900 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10658 CustomerID=QUICK EmployeeID=4 OrderDate=9/5/1997 RequiredDate=10/3/1997 ShippedDate=9/8/1997 ShipVia=1 Freight=364.1500 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10659 CustomerID=QUEEN EmployeeID=7 OrderDate=9/5/1997 RequiredDate=10/3/1997 ShippedDate=9/10/1997 ShipVia=2 Freight=105.8100 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10660 CustomerID=HUNGC EmployeeID=8 OrderDate=9/8/1997 RequiredDate=10/6/1997 ShippedDate=10/15/1997 ShipVia=1 Freight=111.2900 ShipName=Hungry Coyote Import Store ShipAddress=City Center Plaza 516 Main St. ShipCity=Elgin ShipRegion=OR ShipPostalCode=97827 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10661 CustomerID=HUNGO EmployeeID=7 OrderDate=9/9/1997 RequiredDate=10/7/1997 ShippedDate=9/15/1997 ShipVia=3 Freight=17.5500 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10662 CustomerID=LONEP EmployeeID=3 OrderDate=9/9/1997 RequiredDate=10/7/1997 ShippedDate=9/18/1997 ShipVia=2 Freight=1.2800 ShipName=Lonesome Pine Restaurant ShipAddress=89 Chiaroscuro Rd. ShipCity=Portland ShipRegion=OR ShipPostalCode=97219 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10663 CustomerID=BONAP EmployeeID=2 OrderDate=9/10/1997 RequiredDate=9/24/1997 ShippedDate=10/3/1997 ShipVia=2 Freight=113.1500 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10664 CustomerID=FURIB EmployeeID=1 OrderDate=9/10/1997 RequiredDate=10/8/1997 ShippedDate=9/19/1997 ShipVia=3 Freight=1.2700 ShipName=Furia Bacalhau e Frutos do Mar ShipAddress=Jardim das rosas n. 32 ShipCity=Lisboa ShipRegion=null ShipPostalCode=1675 ShipCountry=Portugal Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10665 CustomerID=LONEP EmployeeID=1 OrderDate=9/11/1997 RequiredDate=10/9/1997 ShippedDate=9/17/1997 ShipVia=2 Freight=26.3100 ShipName=Lonesome Pine Restaurant ShipAddress=89 Chiaroscuro Rd. ShipCity=Portland ShipRegion=OR ShipPostalCode=97219 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10666 CustomerID=RICSU EmployeeID=7 OrderDate=9/12/1997 RequiredDate=10/10/1997 ShippedDate=9/22/1997 ShipVia=2 Freight=232.4200 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10667 CustomerID=ERNSH EmployeeID=7 OrderDate=9/12/1997 RequiredDate=10/10/1997 ShippedDate=9/19/1997 ShipVia=1 Freight=78.0900 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10668 CustomerID=WANDK EmployeeID=1 OrderDate=9/15/1997 RequiredDate=10/13/1997 ShippedDate=9/23/1997 ShipVia=2 Freight=47.2200 ShipName=Die Wandernde Kuh ShipAddress=Adenauerallee 900 ShipCity=Stuttgart ShipRegion=null ShipPostalCode=70563 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10669 CustomerID=SIMOB EmployeeID=2 OrderDate=9/15/1997 RequiredDate=10/13/1997 ShippedDate=9/22/1997 ShipVia=1 Freight=24.3900 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10670 CustomerID=FRANK EmployeeID=4 OrderDate=9/16/1997 RequiredDate=10/14/1997 ShippedDate=9/18/1997 ShipVia=1 Freight=203.4800 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10671 CustomerID=FRANR EmployeeID=1 OrderDate=9/17/1997 RequiredDate=10/15/1997 ShippedDate=9/24/1997 ShipVia=1 Freight=30.3400 ShipName=France restauration ShipAddress=54, rue Royale ShipCity=Nantes ShipRegion=null ShipPostalCode=44000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10672 CustomerID=BERGS EmployeeID=9 OrderDate=9/17/1997 RequiredDate=10/1/1997 ShippedDate=9/26/1997 ShipVia=2 Freight=95.7500 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10673 CustomerID=WILMK EmployeeID=2 OrderDate=9/18/1997 RequiredDate=10/16/1997 ShippedDate=9/19/1997 ShipVia=1 Freight=22.7600 ShipName=Wilman Kala ShipAddress=Keskuskatu 45 ShipCity=Helsinki ShipRegion=null ShipPostalCode=21240 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10674 CustomerID=ISLAT EmployeeID=4 OrderDate=9/18/1997 RequiredDate=10/16/1997 ShippedDate=9/30/1997 ShipVia=2 Freight=0.9000 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10675 CustomerID=FRANK EmployeeID=5 OrderDate=9/19/1997 RequiredDate=10/17/1997 ShippedDate=9/23/1997 ShipVia=2 Freight=31.8500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10676 CustomerID=TORTU EmployeeID=2 OrderDate=9/22/1997 RequiredDate=10/20/1997 ShippedDate=9/29/1997 ShipVia=2 Freight=2.0100 ShipName=Tortuga Restaurante ShipAddress=Avda. Azteca 123 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05033 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10677 CustomerID=ANTON EmployeeID=1 OrderDate=9/22/1997 RequiredDate=10/20/1997 ShippedDate=9/26/1997 ShipVia=3 Freight=4.0300 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10678 CustomerID=SAVEA EmployeeID=7 OrderDate=9/23/1997 RequiredDate=10/21/1997 ShippedDate=10/16/1997 ShipVia=3 Freight=388.9800 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10679 CustomerID=BLONP EmployeeID=8 OrderDate=9/23/1997 RequiredDate=10/21/1997 ShippedDate=9/30/1997 ShipVia=3 Freight=27.9400 ShipName=Blondel père et fils ShipAddress=24, place Kléber ShipCity=Strasbourg ShipRegion=null ShipPostalCode=67000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10680 CustomerID=OLDWO EmployeeID=1 OrderDate=9/24/1997 RequiredDate=10/22/1997 ShippedDate=9/26/1997 ShipVia=1 Freight=26.6100 ShipName=Old World Delicatessen ShipAddress=2743 Bering St. ShipCity=Anchorage ShipRegion=AK ShipPostalCode=99508 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10681 CustomerID=GREAL EmployeeID=3 OrderDate=9/25/1997 RequiredDate=10/23/1997 ShippedDate=9/30/1997 ShipVia=3 Freight=76.1300 ShipName=Great Lakes Food Market ShipAddress=2732 Baker Blvd. ShipCity=Eugene ShipRegion=OR ShipPostalCode=97403 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10682 CustomerID=ANTON EmployeeID=3 OrderDate=9/25/1997 RequiredDate=10/23/1997 ShippedDate=10/1/1997 ShipVia=2 Freight=36.1300 ShipName=Antonio Moreno Taquería ShipAddress=Mataderos 2312 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05023 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10683 CustomerID=DUMON EmployeeID=2 OrderDate=9/26/1997 RequiredDate=10/24/1997 ShippedDate=10/1/1997 ShipVia=1 Freight=4.4000 ShipName=Du monde entier ShipAddress=67, rue des Cinquante Otages ShipCity=Nantes ShipRegion=null ShipPostalCode=44000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10684 CustomerID=OTTIK EmployeeID=3 OrderDate=9/26/1997 RequiredDate=10/24/1997 ShippedDate=9/30/1997 ShipVia=1 Freight=145.6300 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10685 CustomerID=GOURL EmployeeID=4 OrderDate=9/29/1997 RequiredDate=10/13/1997 ShippedDate=10/3/1997 ShipVia=2 Freight=33.7500 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10686 CustomerID=PICCO EmployeeID=2 OrderDate=9/30/1997 RequiredDate=10/28/1997 ShippedDate=10/8/1997 ShipVia=1 Freight=96.5000 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10687 CustomerID=HUNGO EmployeeID=9 OrderDate=9/30/1997 RequiredDate=10/28/1997 ShippedDate=10/30/1997 ShipVia=2 Freight=296.4300 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10688 CustomerID=VAFFE EmployeeID=4 OrderDate=10/1/1997 RequiredDate=10/15/1997 ShippedDate=10/7/1997 ShipVia=2 Freight=299.0900 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10689 CustomerID=BERGS EmployeeID=1 OrderDate=10/1/1997 RequiredDate=10/29/1997 ShippedDate=10/7/1997 ShipVia=2 Freight=13.4200 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10690 CustomerID=HANAR EmployeeID=1 OrderDate=10/2/1997 RequiredDate=10/30/1997 ShippedDate=10/3/1997 ShipVia=1 Freight=15.8000 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10691 CustomerID=QUICK EmployeeID=2 OrderDate=10/3/1997 RequiredDate=11/14/1997 ShippedDate=10/22/1997 ShipVia=2 Freight=810.0500 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10692 CustomerID=ALFKI EmployeeID=4 OrderDate=10/3/1997 RequiredDate=10/31/1997 ShippedDate=10/13/1997 ShipVia=2 Freight=61.0200 ShipName=Alfred's Futterkiste ShipAddress=Obere Str. 57 ShipCity=Berlin ShipRegion=null ShipPostalCode=12209 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10693 CustomerID=WHITC EmployeeID=3 OrderDate=10/6/1997 RequiredDate=10/20/1997 ShippedDate=10/10/1997 ShipVia=3 Freight=139.3400 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10694 CustomerID=QUICK EmployeeID=8 OrderDate=10/6/1997 RequiredDate=11/3/1997 ShippedDate=10/9/1997 ShipVia=3 Freight=398.3600 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10695 CustomerID=WILMK EmployeeID=7 OrderDate=10/7/1997 RequiredDate=11/18/1997 ShippedDate=10/14/1997 ShipVia=1 Freight=16.7200 ShipName=Wilman Kala ShipAddress=Keskuskatu 45 ShipCity=Helsinki ShipRegion=null ShipPostalCode=21240 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10696 CustomerID=WHITC EmployeeID=8 OrderDate=10/8/1997 RequiredDate=11/19/1997 ShippedDate=10/14/1997 ShipVia=3 Freight=102.5500 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10697 CustomerID=LINOD EmployeeID=3 OrderDate=10/8/1997 RequiredDate=11/5/1997 ShippedDate=10/14/1997 ShipVia=1 Freight=45.5200 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10698 CustomerID=ERNSH EmployeeID=4 OrderDate=10/9/1997 RequiredDate=11/6/1997 ShippedDate=10/17/1997 ShipVia=1 Freight=272.4700 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10699 CustomerID=MORGK EmployeeID=3 OrderDate=10/9/1997 RequiredDate=11/6/1997 ShippedDate=10/13/1997 ShipVia=3 Freight=0.5800 ShipName=Morgenstern Gesundkost ShipAddress=Heerstr. 22 ShipCity=Leipzig ShipRegion=null ShipPostalCode=04179 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10700 CustomerID=SAVEA EmployeeID=3 OrderDate=10/10/1997 RequiredDate=11/7/1997 ShippedDate=10/16/1997 ShipVia=1 Freight=65.1000 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10701 CustomerID=HUNGO EmployeeID=6 OrderDate=10/13/1997 RequiredDate=10/27/1997 ShippedDate=10/15/1997 ShipVia=3 Freight=220.3100 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10702 CustomerID=ALFKI EmployeeID=4 OrderDate=10/13/1997 RequiredDate=11/24/1997 ShippedDate=10/21/1997 ShipVia=1 Freight=23.9400 ShipName=Alfred's Futterkiste ShipAddress=Obere Str. 57 ShipCity=Berlin ShipRegion=null ShipPostalCode=12209 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10703 CustomerID=FOLKO EmployeeID=6 OrderDate=10/14/1997 RequiredDate=11/11/1997 ShippedDate=10/20/1997 ShipVia=2 Freight=152.3000 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10704 CustomerID=QUEEN EmployeeID=6 OrderDate=10/14/1997 RequiredDate=11/11/1997 ShippedDate=11/7/1997 ShipVia=1 Freight=4.7800 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10705 CustomerID=HILAA EmployeeID=9 OrderDate=10/15/1997 RequiredDate=11/12/1997 ShippedDate=11/18/1997 ShipVia=2 Freight=3.5200 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10706 CustomerID=OLDWO EmployeeID=8 OrderDate=10/16/1997 RequiredDate=11/13/1997 ShippedDate=10/21/1997 ShipVia=3 Freight=135.6300 ShipName=Old World Delicatessen ShipAddress=2743 Bering St. ShipCity=Anchorage ShipRegion=AK ShipPostalCode=99508 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10707 CustomerID=AROUT EmployeeID=4 OrderDate=10/16/1997 RequiredDate=10/30/1997 ShippedDate=10/23/1997 ShipVia=3 Freight=21.7400 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10708 CustomerID=THEBI EmployeeID=6 OrderDate=10/17/1997 RequiredDate=11/28/1997 ShippedDate=11/5/1997 ShipVia=2 Freight=2.9600 ShipName=The Big Cheese ShipAddress=89 Jefferson Way Suite 2 ShipCity=Portland ShipRegion=OR ShipPostalCode=97201 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10709 CustomerID=GOURL EmployeeID=1 OrderDate=10/17/1997 RequiredDate=11/14/1997 ShippedDate=11/20/1997 ShipVia=3 Freight=210.8000 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10710 CustomerID=FRANS EmployeeID=1 OrderDate=10/20/1997 RequiredDate=11/17/1997 ShippedDate=10/23/1997 ShipVia=1 Freight=4.9800 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10711 CustomerID=SAVEA EmployeeID=5 OrderDate=10/21/1997 RequiredDate=12/2/1997 ShippedDate=10/29/1997 ShipVia=2 Freight=52.4100 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10712 CustomerID=HUNGO EmployeeID=3 OrderDate=10/21/1997 RequiredDate=11/18/1997 ShippedDate=10/31/1997 ShipVia=1 Freight=89.9300 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10713 CustomerID=SAVEA EmployeeID=1 OrderDate=10/22/1997 RequiredDate=11/19/1997 ShippedDate=10/24/1997 ShipVia=1 Freight=167.0500 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10714 CustomerID=SAVEA EmployeeID=5 OrderDate=10/22/1997 RequiredDate=11/19/1997 ShippedDate=10/27/1997 ShipVia=3 Freight=24.4900 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10715 CustomerID=BONAP EmployeeID=3 OrderDate=10/23/1997 RequiredDate=11/6/1997 ShippedDate=10/29/1997 ShipVia=1 Freight=63.2000 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10716 CustomerID=RANCH EmployeeID=4 OrderDate=10/24/1997 RequiredDate=11/21/1997 ShippedDate=10/27/1997 ShipVia=2 Freight=22.5700 ShipName=Rancho grande ShipAddress=Av. del Libertador 900 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10717 CustomerID=FRANK EmployeeID=1 OrderDate=10/24/1997 RequiredDate=11/21/1997 ShippedDate=10/29/1997 ShipVia=2 Freight=59.2500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10718 CustomerID=KOENE EmployeeID=1 OrderDate=10/27/1997 RequiredDate=11/24/1997 ShippedDate=10/29/1997 ShipVia=3 Freight=170.8800 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10719 CustomerID=LETSS EmployeeID=8 OrderDate=10/27/1997 RequiredDate=11/24/1997 ShippedDate=11/5/1997 ShipVia=2 Freight=51.4400 ShipName=Let's Stop N Shop ShipAddress=87 Polk St. Suite 5 ShipCity=San Francisco ShipRegion=CA ShipPostalCode=94117 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10720 CustomerID=QUEDE EmployeeID=8 OrderDate=10/28/1997 RequiredDate=11/11/1997 ShippedDate=11/5/1997 ShipVia=2 Freight=9.5300 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10721 CustomerID=QUICK EmployeeID=5 OrderDate=10/29/1997 RequiredDate=11/26/1997 ShippedDate=10/31/1997 ShipVia=3 Freight=48.9200 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10722 CustomerID=SAVEA EmployeeID=8 OrderDate=10/29/1997 RequiredDate=12/10/1997 ShippedDate=11/4/1997 ShipVia=1 Freight=74.5800 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10723 CustomerID=WHITC EmployeeID=3 OrderDate=10/30/1997 RequiredDate=11/27/1997 ShippedDate=11/25/1997 ShipVia=1 Freight=21.7200 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10724 CustomerID=MEREP EmployeeID=8 OrderDate=10/30/1997 RequiredDate=12/11/1997 ShippedDate=11/5/1997 ShipVia=2 Freight=57.7500 ShipName=Mère Paillarde ShipAddress=43 rue St. Laurent ShipCity=Montréal ShipRegion=Québec ShipPostalCode=H1J 1C3 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10725 CustomerID=FAMIA EmployeeID=4 OrderDate=10/31/1997 RequiredDate=11/28/1997 ShippedDate=11/5/1997 ShipVia=3 Freight=10.8300 ShipName=Familia Arquibaldo ShipAddress=Rua Orós, 92 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05442-030 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10726 CustomerID=EASTC EmployeeID=4 OrderDate=11/3/1997 RequiredDate=11/17/1997 ShippedDate=12/5/1997 ShipVia=1 Freight=16.5600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10727 CustomerID=REGGC EmployeeID=2 OrderDate=11/3/1997 RequiredDate=12/1/1997 ShippedDate=12/5/1997 ShipVia=1 Freight=89.9000 ShipName=Reggiani Caseifici ShipAddress=Strada Provinciale 124 ShipCity=Reggio Emilia ShipRegion=null ShipPostalCode=42100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10728 CustomerID=QUEEN EmployeeID=4 OrderDate=11/4/1997 RequiredDate=12/2/1997 ShippedDate=11/11/1997 ShipVia=2 Freight=58.3300 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10729 CustomerID=LINOD EmployeeID=8 OrderDate=11/4/1997 RequiredDate=12/16/1997 ShippedDate=11/14/1997 ShipVia=3 Freight=141.0600 ShipName=LINO-Delicateses ShipAddress=Ave. 5 de Mayo Porlamar ShipCity=I. de Margarita ShipRegion=Nueva Esparta ShipPostalCode=4980 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10730 CustomerID=BONAP EmployeeID=5 OrderDate=11/5/1997 RequiredDate=12/3/1997 ShippedDate=11/14/1997 ShipVia=1 Freight=20.1200 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10731 CustomerID=CHOPS EmployeeID=7 OrderDate=11/6/1997 RequiredDate=12/4/1997 ShippedDate=11/14/1997 ShipVia=1 Freight=96.6500 ShipName=Chop-suey Chinese ShipAddress=Hauptstr. 31 ShipCity=Bern ShipRegion=null ShipPostalCode=3012 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10732 CustomerID=BONAP EmployeeID=3 OrderDate=11/6/1997 RequiredDate=12/4/1997 ShippedDate=11/7/1997 ShipVia=1 Freight=16.9700 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10733 CustomerID=BERGS EmployeeID=1 OrderDate=11/7/1997 RequiredDate=12/5/1997 ShippedDate=11/10/1997 ShipVia=3 Freight=110.1100 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10734 CustomerID=GOURL EmployeeID=2 OrderDate=11/7/1997 RequiredDate=12/5/1997 ShippedDate=11/12/1997 ShipVia=3 Freight=1.6300 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10735 CustomerID=LETSS EmployeeID=6 OrderDate=11/10/1997 RequiredDate=12/8/1997 ShippedDate=11/21/1997 ShipVia=2 Freight=45.9700 ShipName=Let's Stop N Shop ShipAddress=87 Polk St. Suite 5 ShipCity=San Francisco ShipRegion=CA ShipPostalCode=94117 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10736 CustomerID=HUNGO EmployeeID=9 OrderDate=11/11/1997 RequiredDate=12/9/1997 ShippedDate=11/21/1997 ShipVia=2 Freight=44.1000 ShipName=Hungry Owl All-Night Grocers ShipAddress=8 Johnstown Road ShipCity=Cork ShipRegion=Co. Cork ShipPostalCode=null ShipCountry=Ireland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10737 CustomerID=VINET EmployeeID=2 OrderDate=11/11/1997 RequiredDate=12/9/1997 ShippedDate=11/18/1997 ShipVia=2 Freight=7.7900 ShipName=Vins et alcools Chevalier ShipAddress=59 rue de l'Abbaye ShipCity=Reims ShipRegion=null ShipPostalCode=51100 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10738 CustomerID=SPECD EmployeeID=2 OrderDate=11/12/1997 RequiredDate=12/10/1997 ShippedDate=11/18/1997 ShipVia=1 Freight=2.9100 ShipName=Spécialités du monde ShipAddress=25, rue Lauriston ShipCity=Paris ShipRegion=null ShipPostalCode=75016 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10739 CustomerID=VINET EmployeeID=3 OrderDate=11/12/1997 RequiredDate=12/10/1997 ShippedDate=11/17/1997 ShipVia=3 Freight=11.0800 ShipName=Vins et alcools Chevalier ShipAddress=59 rue de l'Abbaye ShipCity=Reims ShipRegion=null ShipPostalCode=51100 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10740 CustomerID=WHITC EmployeeID=4 OrderDate=11/13/1997 RequiredDate=12/11/1997 ShippedDate=11/25/1997 ShipVia=2 Freight=81.8800 ShipName=White Clover Markets ShipAddress=1029 - 12th Ave. S. ShipCity=Seattle ShipRegion=WA ShipPostalCode=98124 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10741 CustomerID=AROUT EmployeeID=4 OrderDate=11/14/1997 RequiredDate=11/28/1997 ShippedDate=11/18/1997 ShipVia=3 Freight=10.9600 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10742 CustomerID=BOTTM EmployeeID=3 OrderDate=11/14/1997 RequiredDate=12/12/1997 ShippedDate=11/18/1997 ShipVia=3 Freight=243.7300 ShipName=Bottom-Dollar Markets ShipAddress=23 Tsawassen Blvd. ShipCity=Tsawassen ShipRegion=BC ShipPostalCode=T2F 8M4 ShipCountry=Canada Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10743 CustomerID=AROUT EmployeeID=1 OrderDate=11/17/1997 RequiredDate=12/15/1997 ShippedDate=11/21/1997 ShipVia=2 Freight=23.7200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10744 CustomerID=VAFFE EmployeeID=6 OrderDate=11/17/1997 RequiredDate=12/15/1997 ShippedDate=11/24/1997 ShipVia=1 Freight=69.1900 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10745 CustomerID=QUICK EmployeeID=9 OrderDate=11/18/1997 RequiredDate=12/16/1997 ShippedDate=11/27/1997 ShipVia=1 Freight=3.5200 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10746 CustomerID=CHOPS EmployeeID=1 OrderDate=11/19/1997 RequiredDate=12/17/1997 ShippedDate=11/21/1997 ShipVia=3 Freight=31.4300 ShipName=Chop-suey Chinese ShipAddress=Hauptstr. 31 ShipCity=Bern ShipRegion=null ShipPostalCode=3012 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10747 CustomerID=PICCO EmployeeID=6 OrderDate=11/19/1997 RequiredDate=12/17/1997 ShippedDate=11/26/1997 ShipVia=1 Freight=117.3300 ShipName=Piccolo und mehr ShipAddress=Geislweg 14 ShipCity=Salzburg ShipRegion=null ShipPostalCode=5020 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10748 CustomerID=SAVEA EmployeeID=3 OrderDate=11/20/1997 RequiredDate=12/18/1997 ShippedDate=11/28/1997 ShipVia=1 Freight=232.5500 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10749 CustomerID=ISLAT EmployeeID=4 OrderDate=11/20/1997 RequiredDate=12/18/1997 ShippedDate=12/19/1997 ShipVia=2 Freight=61.5300 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10750 CustomerID=WARTH EmployeeID=9 OrderDate=11/21/1997 RequiredDate=12/19/1997 ShippedDate=11/24/1997 ShipVia=1 Freight=79.3000 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10751 CustomerID=RICSU EmployeeID=3 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=12/3/1997 ShipVia=3 Freight=130.7900 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10752 CustomerID=NORTS EmployeeID=2 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=11/28/1997 ShipVia=3 Freight=1.3900 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10753 CustomerID=FRANS EmployeeID=3 OrderDate=11/25/1997 RequiredDate=12/23/1997 ShippedDate=11/27/1997 ShipVia=1 Freight=7.7000 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10754 CustomerID=MAGAA EmployeeID=6 OrderDate=11/25/1997 RequiredDate=12/23/1997 ShippedDate=11/27/1997 ShipVia=3 Freight=2.3800 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10755 CustomerID=BONAP EmployeeID=4 OrderDate=11/26/1997 RequiredDate=12/24/1997 ShippedDate=11/28/1997 ShipVia=2 Freight=16.7100 ShipName=Bon app' ShipAddress=12, rue des Bouchers ShipCity=Marseille ShipRegion=null ShipPostalCode=13008 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10756 CustomerID=SPLIR EmployeeID=8 OrderDate=11/27/1997 RequiredDate=12/25/1997 ShippedDate=12/2/1997 ShipVia=2 Freight=73.2100 ShipName=Split Rail Beer & Ale ShipAddress=P.O. Box 555 ShipCity=Lander ShipRegion=WY ShipPostalCode=82520 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10757 CustomerID=SAVEA EmployeeID=6 OrderDate=11/27/1997 RequiredDate=12/25/1997 ShippedDate=12/15/1997 ShipVia=1 Freight=8.1900 ShipName=Save-a-lot Markets ShipAddress=187 Suffolk Ln. ShipCity=Boise ShipRegion=ID ShipPostalCode=83720 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10758 CustomerID=RICSU EmployeeID=3 OrderDate=11/28/1997 RequiredDate=12/26/1997 ShippedDate=12/4/1997 ShipVia=3 Freight=138.1700 ShipName=Richter Supermarkt ShipAddress=Starenweg 5 ShipCity=Genève ShipRegion=null ShipPostalCode=1204 ShipCountry=Switzerland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10759 CustomerID=ANATR EmployeeID=3 OrderDate=11/28/1997 RequiredDate=12/26/1997 ShippedDate=12/12/1997 ShipVia=3 Freight=11.9900 ShipName=Ana Trujillo Emparedados y helados ShipAddress=Avda. de la Constitución 2222 ShipCity=México D.F. ShipRegion=null ShipPostalCode=05021 ShipCountry=Mexico Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10760 CustomerID=MAISD EmployeeID=4 OrderDate=12/1/1997 RequiredDate=12/29/1997 ShippedDate=12/10/1997 ShipVia=1 Freight=155.6400 ShipName=Maison Dewey ShipAddress=Rue Joseph-Bens 532 ShipCity=Bruxelles ShipRegion=null ShipPostalCode=B-1180 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10761 CustomerID=RATTC EmployeeID=5 OrderDate=12/2/1997 RequiredDate=12/30/1997 ShippedDate=12/8/1997 ShipVia=2 Freight=18.6600 ShipName=Rattlesnake Canyon Grocery ShipAddress=2817 Milton Dr. ShipCity=Albuquerque ShipRegion=NM ShipPostalCode=87110 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10762 CustomerID=FOLKO EmployeeID=3 OrderDate=12/2/1997 RequiredDate=12/30/1997 ShippedDate=12/9/1997 ShipVia=1 Freight=328.7400 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10763 CustomerID=FOLIG EmployeeID=3 OrderDate=12/3/1997 RequiredDate=12/31/1997 ShippedDate=12/8/1997 ShipVia=3 Freight=37.3500 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10764 CustomerID=ERNSH EmployeeID=6 OrderDate=12/3/1997 RequiredDate=12/31/1997 ShippedDate=12/8/1997 ShipVia=3 Freight=145.4500 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10765 CustomerID=QUICK EmployeeID=3 OrderDate=12/4/1997 RequiredDate=1/1/1998 ShippedDate=12/9/1997 ShipVia=3 Freight=42.7400 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10766 CustomerID=OTTIK EmployeeID=4 OrderDate=12/5/1997 RequiredDate=1/2/1998 ShippedDate=12/9/1997 ShipVia=1 Freight=157.5500 ShipName=Ottilies Käseladen ShipAddress=Mehrheimerstr. 369 ShipCity=Köln ShipRegion=null ShipPostalCode=50739 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10767 CustomerID=SUPRD EmployeeID=4 OrderDate=12/5/1997 RequiredDate=1/2/1998 ShippedDate=12/15/1997 ShipVia=3 Freight=1.5900 ShipName=Suprêmes délices ShipAddress=Boulevard Tirou, 255 ShipCity=Charleroi ShipRegion=null ShipPostalCode=B-6000 ShipCountry=Belgium Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10768 CustomerID=AROUT EmployeeID=3 OrderDate=12/8/1997 RequiredDate=1/5/1998 ShippedDate=12/15/1997 ShipVia=2 Freight=146.3200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10769 CustomerID=VAFFE EmployeeID=3 OrderDate=12/8/1997 RequiredDate=1/5/1998 ShippedDate=12/12/1997 ShipVia=1 Freight=65.0600 ShipName=Vaffeljernet ShipAddress=Smagsloget 45 ShipCity=Århus ShipRegion=null ShipPostalCode=8200 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10770 CustomerID=HANAR EmployeeID=8 OrderDate=12/9/1997 RequiredDate=1/6/1998 ShippedDate=12/17/1997 ShipVia=3 Freight=5.3200 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10771 CustomerID=ERNSH EmployeeID=9 OrderDate=12/10/1997 RequiredDate=1/7/1998 ShippedDate=1/2/1998 ShipVia=2 Freight=11.1900 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10772 CustomerID=LEHMS EmployeeID=3 OrderDate=12/10/1997 RequiredDate=1/7/1998 ShippedDate=12/19/1997 ShipVia=2 Freight=91.2800 ShipName=Lehmanns Marktstand ShipAddress=Magazinweg 7 ShipCity=Frankfurt a.M. ShipRegion=null ShipPostalCode=60528 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10773 CustomerID=ERNSH EmployeeID=1 OrderDate=12/11/1997 RequiredDate=1/8/1998 ShippedDate=12/16/1997 ShipVia=3 Freight=96.4300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10774 CustomerID=FOLKO EmployeeID=4 OrderDate=12/11/1997 RequiredDate=12/25/1997 ShippedDate=12/12/1997 ShipVia=1 Freight=48.2000 ShipName=Folk och fä HB ShipAddress=Åkergatan 24 ShipCity=Bräcke ShipRegion=null ShipPostalCode=S-844 67 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10775 CustomerID=THECR EmployeeID=7 OrderDate=12/12/1997 RequiredDate=1/9/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=20.2500 ShipName=The Cracker Box ShipAddress=55 Grizzly Peak Rd. ShipCity=Butte ShipRegion=MT ShipPostalCode=59801 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10776 CustomerID=ERNSH EmployeeID=1 OrderDate=12/15/1997 RequiredDate=1/12/1998 ShippedDate=12/18/1997 ShipVia=3 Freight=351.5300 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10777 CustomerID=GOURL EmployeeID=7 OrderDate=12/15/1997 RequiredDate=12/29/1997 ShippedDate=1/21/1998 ShipVia=2 Freight=3.0100 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10778 CustomerID=BERGS EmployeeID=3 OrderDate=12/16/1997 RequiredDate=1/13/1998 ShippedDate=12/24/1997 ShipVia=1 Freight=6.7900 ShipName=Berglunds snabbköp ShipAddress=Berguvsvägen 8 ShipCity=Luleå ShipRegion=null ShipPostalCode=S-958 22 ShipCountry=Sweden Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10779 CustomerID=MORGK EmployeeID=3 OrderDate=12/16/1997 RequiredDate=1/13/1998 ShippedDate=1/14/1998 ShipVia=2 Freight=58.1300 ShipName=Morgenstern Gesundkost ShipAddress=Heerstr. 22 ShipCity=Leipzig ShipRegion=null ShipPostalCode=04179 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10780 CustomerID=LILAS EmployeeID=2 OrderDate=12/16/1997 RequiredDate=12/30/1997 ShippedDate=12/25/1997 ShipVia=1 Freight=42.1300 ShipName=LILA-Supermercado ShipAddress=Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity=Barquisimeto ShipRegion=Lara ShipPostalCode=3508 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10781 CustomerID=WARTH EmployeeID=2 OrderDate=12/17/1997 RequiredDate=1/14/1998 ShippedDate=12/19/1997 ShipVia=3 Freight=73.1600 ShipName=Wartian Herkku ShipAddress=Torikatu 38 ShipCity=Oulu ShipRegion=null ShipPostalCode=90110 ShipCountry=Finland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10782 CustomerID=CACTU EmployeeID=9 OrderDate=12/17/1997 RequiredDate=1/14/1998 ShippedDate=12/22/1997 ShipVia=3 Freight=1.1000 ShipName=Cactus Comidas para llevar ShipAddress=Cerrito 333 ShipCity=Buenos Aires ShipRegion=null ShipPostalCode=1010 ShipCountry=Argentina Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10783 CustomerID=HANAR EmployeeID=4 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/19/1997 ShipVia=2 Freight=124.9800 ShipName=Hanari Carnes ShipAddress=Rua do Paço, 67 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=05454-876 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10784 CustomerID=MAGAA EmployeeID=4 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/22/1997 ShipVia=3 Freight=70.0900 ShipName=Magazzini Alimentari Riuniti ShipAddress=Via Ludovico il Moro 22 ShipCity=Bergamo ShipRegion=null ShipPostalCode=24100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10785 CustomerID=GROSR EmployeeID=1 OrderDate=12/18/1997 RequiredDate=1/15/1998 ShippedDate=12/24/1997 ShipVia=3 Freight=1.5100 ShipName=GROSELLA-Restaurante ShipAddress=5ª Ave. Los Palos Grandes ShipCity=Caracas ShipRegion=DF ShipPostalCode=1081 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10786 CustomerID=QUEEN EmployeeID=8 OrderDate=12/19/1997 RequiredDate=1/16/1998 ShippedDate=12/23/1997 ShipVia=1 Freight=110.8700 ShipName=Queen Cozinha ShipAddress=Alameda dos Canàrios, 891 ShipCity=Sao Paulo ShipRegion=SP ShipPostalCode=05487-020 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10787 CustomerID=LAMAI EmployeeID=2 OrderDate=12/19/1997 RequiredDate=1/2/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=249.9300 ShipName=La maison d'Asie ShipAddress=1 rue Alsace-Lorraine ShipCity=Toulouse ShipRegion=null ShipPostalCode=31000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10788 CustomerID=QUICK EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=1/19/1998 ShipVia=2 Freight=42.7000 ShipName=QUICK-Stop ShipAddress=Taucherstraße 10 ShipCity=Cunewalde ShipRegion=null ShipPostalCode=01307 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10789 CustomerID=FOLIG EmployeeID=1 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=12/31/1997 ShipVia=2 Freight=100.6000 ShipName=Folies gourmandes ShipAddress=184, chaussée de Tournai ShipCity=Lille ShipRegion=null ShipPostalCode=59000 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10790 CustomerID=GOURL EmployeeID=6 OrderDate=12/22/1997 RequiredDate=1/19/1998 ShippedDate=12/26/1997 ShipVia=1 Freight=28.2300 ShipName=Gourmet Lanchonetes ShipAddress=Av. Brasil, 442 ShipCity=Campinas ShipRegion=SP ShipPostalCode=04876-786 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10791 CustomerID=FRANK EmployeeID=6 OrderDate=12/23/1997 RequiredDate=1/20/1998 ShippedDate=1/1/1998 ShipVia=2 Freight=16.8500 ShipName=Frankenversand ShipAddress=Berliner Platz 43 ShipCity=München ShipRegion=null ShipPostalCode=80805 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10792 CustomerID=WOLZA EmployeeID=1 OrderDate=12/23/1997 RequiredDate=1/20/1998 ShippedDate=12/31/1997 ShipVia=3 Freight=23.7900 ShipName=Wolski Zajazd ShipAddress=ul. Filtrowa 68 ShipCity=Warszawa ShipRegion=null ShipPostalCode=01-012 ShipCountry=Poland Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10793 CustomerID=AROUT EmployeeID=3 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/8/1998 ShipVia=3 Freight=4.5200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10794 CustomerID=QUEDE EmployeeID=6 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/2/1998 ShipVia=1 Freight=21.4900 ShipName=Que Delícia ShipAddress=Rua da Panificadora, 12 ShipCity=Rio de Janeiro ShipRegion=RJ ShipPostalCode=02389-673 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10795 CustomerID=ERNSH EmployeeID=8 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/20/1998 ShipVia=2 Freight=126.6600 ShipName=Ernst Handel ShipAddress=Kirchgasse 6 ShipCity=Graz ShipRegion=null ShipPostalCode=8010 ShipCountry=Austria Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10796 CustomerID=HILAA EmployeeID=3 OrderDate=12/25/1997 RequiredDate=1/22/1998 ShippedDate=1/14/1998 ShipVia=1 Freight=26.5200 ShipName=HILARION-Abastos ShipAddress=Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity=San Cristóbal ShipRegion=Táchira ShipPostalCode=5022 ShipCountry=Venezuela Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10797 CustomerID=DRACD EmployeeID=7 OrderDate=12/25/1997 RequiredDate=1/22/1998 ShippedDate=1/5/1998 ShipVia=2 Freight=33.3500 ShipName=Drachenblut Delikatessen ShipAddress=Walserweg 21 ShipCity=Aachen ShipRegion=null ShipPostalCode=52066 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10798 CustomerID=ISLAT EmployeeID=2 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=1 Freight=2.3300 ShipName=Island Trading ShipAddress=Garden House Crowther Way ShipCity=Cowes ShipRegion=Isle of Wight ShipPostalCode=PO31 7PJ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10799 CustomerID=KOENE EmployeeID=9 OrderDate=12/26/1997 RequiredDate=2/6/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=30.7600 ShipName=Königlich Essen ShipAddress=Maubelstr. 90 ShipCity=Brandenburg ShipRegion=null ShipPostalCode=14776 ShipCountry=Germany Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10800 CustomerID=SEVES EmployeeID=1 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=137.4400 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10801 CustomerID=BOLID EmployeeID=4 OrderDate=12/29/1997 RequiredDate=1/26/1998 ShippedDate=12/31/1997 ShipVia=2 Freight=97.0900 ShipName=Bólido Comidas preparadas ShipAddress=C/ Araquil, 67 ShipCity=Madrid ShipRegion=null ShipPostalCode=28023 ShipCountry=Spain Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10802 CustomerID=SIMOB EmployeeID=4 OrderDate=12/29/1997 RequiredDate=1/26/1998 ShippedDate=1/2/1998 ShipVia=2 Freight=257.2600 ShipName=Simons bistro ShipAddress=Vinbæltet 34 ShipCity=Kobenhavn ShipRegion=null ShipPostalCode=1734 ShipCountry=Denmark Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10803 CustomerID=WELLI EmployeeID=4 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/6/1998 ShipVia=1 Freight=55.2300 ShipName=Wellington Importadora ShipAddress=Rua do Mercado, 12 ShipCity=Resende ShipRegion=SP ShipPostalCode=08737-363 ShipCountry=Brazil Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10804 CustomerID=SEVES EmployeeID=6 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipVia=2 Freight=27.3300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10805 CustomerID=THEBI EmployeeID=2 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/9/1998 ShipVia=3 Freight=237.3400 ShipName=The Big Cheese ShipAddress=89 Jefferson Way Suite 2 ShipCity=Portland ShipRegion=OR ShipPostalCode=97201 ShipCountry=USA Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10806 CustomerID=VICTE EmployeeID=3 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/5/1998 ShipVia=2 Freight=22.1100 ShipName=Victuailles en stock ShipAddress=2, rue du Commerce ShipCity=Lyon ShipRegion=null ShipPostalCode=69004 ShipCountry=France Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10807 CustomerID=FRANS EmployeeID=4 OrderDate=12/31/1997 RequiredDate=1/28/1998 ShippedDate=1/30/1998 ShipVia=1 Freight=1.3600 ShipName=Franchi S.p.A. ShipAddress=Via Monte Bianco 34 ShipCity=Torino ShipRegion=null ShipPostalCode=10100 ShipCountry=Italy Order_Details=... Employee={ } Customer={ } Shipper={ }
This sample uses the Substring method to return Product names starting from the fourth letter.
Public Sub LinqToSqlString07()
Dim q = From p In db.Products _
Select p.ProductName.Substring(3)
ObjectDumper.Write(q)
End Sub
Result:
ce Mutton
seed Syrup
ton Crab Meat
embert Pierrot
narvon Tigers
i
ng
rtreuse verte
f Anton's Cajun Seasoning
f Anton's Gumbo Mix
colade
e de Blaye
argots de Bourgogne
o Mix
temysost
tost
en Shouyu
cchi di nonna Alice
gonzola Telino
ndma's Boysenberry Spread
vad lax
raná Fantástica
brandsdalsost
a Malacca
bär Gummibärchen
taf's Knäckebröd
ra
agd Sill
h Coffee
k's New England Clam Chowder
bu
kalikööri
ghing Lumberjack Lager
glife Tofu
isiana Fiery Hot Pepper Sauce
isiana Hot Spiced Okra
jimup Dried Apples
carpone Fabioli
ilaku
hi Kobe Niku
zarella di Giovanni
d-Ost Matjeshering
thwoods Cranberry Sauce
uCa Nuß-Nougat-Creme
ginal Frankfurter grüne Soße
back Lager
é chinois
lova
th Pasties
so Cabrales
so Manchego La Pastora
lette Courdavault
ioli Angelo
nbräu Klosterbier
Kaviar
ede sild
sle Sauerkraut
quatch Ale
oggi Schokolade
ttish Longbreads
gaporean Hokkien Fried Mee
Rodney's Marmalade
Rodney's Scones
op d'érable
gesild
eleye Stout
te au sucre
time Chocolate Biscuits
ringer Rostbratwurst
u
rtière
nbröd
le Bob's Organic Dried Pears
koinen suklaa
ie-spread
mers gute Semmelknödel
nse koeken
This sample uses the Substring method to find Employees whose home phone numbers have '555' as the seventh through ninth digits.
Public Sub LinqToSqlString08()
Dim q = From e In db.Employees _
Where e.HomePhone.Substring(6, 3) = "555" _
Select e
ObjectDumper.Write(q)
End Sub
Result:
EmployeeID=1 LastName=Davolio FirstName=Nancy Title=Sales Representative TitleOfCourtesy=Ms. BirthDate=12/8/1948 HireDate=5/1/1992 Address=507 - 20th Ave. E.
Apt. 2A City=Seattle Region=WA PostalCode=98122 Country=USA HomePhone=(206) 555-9857 Extension=5467 Photo=... Notes=Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International. ReportsTo=2 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=2 LastName=Fuller FirstName=Andrew Title=Vice President, Sales TitleOfCourtesy=Dr. BirthDate=2/19/1952 HireDate=8/14/1992 Address=908 W. Capital Way City=Tacoma Region=WA PostalCode=98401 Country=USA HomePhone=(206) 555-9482 Extension=3457 Photo=... Notes=Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association. ReportsTo=null PhotoPath=http://accweb/emmployees/fuller.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=3 LastName=Leverling FirstName=Janet Title=Sales Representative TitleOfCourtesy=Ms. BirthDate=8/30/1963 HireDate=4/1/1992 Address=722 Moss Bay Blvd. City=Kirkland Region=WA PostalCode=98033 Country=USA HomePhone=(206) 555-3412 Extension=3355 Photo=... Notes=Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992. ReportsTo=2 PhotoPath=http://accweb/emmployees/leverling.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=4 LastName=Peacock FirstName=Margaret Title=Sales Representative TitleOfCourtesy=Mrs. BirthDate=9/19/1937 HireDate=5/3/1993 Address=4110 Old Redmond Rd. City=Redmond Region=WA PostalCode=98052 Country=USA HomePhone=(206) 555-8122 Extension=5176 Photo=... Notes=Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992. ReportsTo=2 PhotoPath=http://accweb/emmployees/peacock.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
EmployeeID=8 LastName=Callahan FirstName=Laura Title=Inside Sales Coordinator TitleOfCourtesy=Ms. BirthDate=1/9/1958 HireDate=3/5/1994 Address=4726 - 11th Ave. N.E. City=Seattle Region=WA PostalCode=98105 Country=USA HomePhone=(206) 555-1189 Extension=2344 Photo=... Notes=Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French. ReportsTo=2 PhotoPath=http://accweb/emmployees/davolio.bmp Orders=... EmployeeTerritories=... Employees=... Employee={ }
This sample uses the ToUpper method to return Employee names where the last name has been converted to uppercase.
Public Sub LinqToSqlString09()
Dim q = From e In db.Employees _
Select LastName = e.LastName.ToUpper(), e.FirstName
ObjectDumper.Write(q)
End Sub
Result:
FirstName=Nancy LastName=DAVOLIO
FirstName=Andrew LastName=FULLER
FirstName=Janet LastName=LEVERLING
FirstName=Margaret LastName=PEACOCK
FirstName=Steven LastName=BUCHANAN
FirstName=Michael LastName=SUYAMA
FirstName=Robert LastName=KING
FirstName=Laura LastName=CALLAHAN
FirstName=Anne LastName=DODSWORTH
This sample uses the ToLower method to return Category names that have been converted to lowercase.
Public Sub LinqToSqlString10()
Dim q = From c In db.Categories _
Select c.CategoryName.ToLower()
ObjectDumper.Write(q)
End Sub
Result:
beverages
condiments
confections
dairy products
grains/cereals
meat/poultry
new beverages
new beverages
new beverages
new beverages
new beverages
new beverages
new beverages
new beverages
new beverages
new beverages
produce
seafood
This sample uses the Trim method to return the first five digits of Employee home phone numbers, with leading and trailing spaces removed.
Public Sub LinqToSqlString11()
Dim q = From e In db.Employees _
Select e.HomePhone.Substring(0, 5).Trim()
ObjectDumper.Write(q)
End Sub
Result:
(206)
(206)
(206)
(206)
(71)
(71)
(71)
(206)
(71)
This sample uses the Insert method to return a sequence of employee phone numbers that have a ) in the fifth position, inserting a : after the ).
Public Sub LinqToSqlString12()
Dim q = From e In db.Employees _
Where e.HomePhone.Substring(4, 1) = ")" _
Select e.HomePhone.Insert(5, ":")
ObjectDumper.Write(q)
End Sub
Result:
(206): 555-9857
(206): 555-9482
(206): 555-3412
(206): 555-8122
(206): 555-1189
This sample uses the Insert method to return a sequence of employee phone numbers that have a ) in the fifth position, removing all characters starting from the tenth character.
Public Sub LinqToSqlString13()
Dim q = From e In db.Employees _
Where e.HomePhone.Substring(4, 1) = ")" _
Select e.HomePhone.Remove(9)
ObjectDumper.Write(q)
End Sub
Result:
(206) 555
(206) 555
(206) 555
(206) 555
(206) 555
This sample uses the Insert method to return a sequence of employee phone numbers that have a ) in the fifth position, removing the first six characters.
Public Sub LinqToSqlString14()
Dim q = From e In db.Employees _
Where e.HomePhone.Substring(4, 1) = ")" _
Select e.HomePhone.Remove(0, 6)
ObjectDumper.Write(q)
End Sub
Result:
555-9857
555-9482
555-3412
555-8122
555-1189
This sample uses the Replace method to return a sequence of Supplier information where the Country field has had UK replaced with United Kingdom and USA replaced with United States of America.
Public Sub LinqToSqlString15()
Dim q = From s In db.Suppliers _
Select s.CompanyName, Country = s.Country.Replace("UK", "United Kingdom").Replace("USA", "United States of America")
ObjectDumper.Write(q)
End Sub
Result:
CompanyName=Exotic Liquids Country=United Kingdom
CompanyName=New Orleans Cajun Delights Country=United States of America
CompanyName=Grandma Kelly's Homestead Country=United States of America
CompanyName=Tokyo Traders Country=Japan
CompanyName=Cooperativa de Quesos 'Las Cabras' Country=Spain
CompanyName=Mayumi's Country=Japan
CompanyName=Pavlova, Ltd. Country=Australia
CompanyName=Specialty Biscuits, Ltd. Country=United Kingdom
CompanyName=PB Knäckebröd AB Country=Sweden
CompanyName=Refrescos Americanas LTDA Country=Brazil
CompanyName=Heli Süßwaren GmbH & Co. KG Country=Germany
CompanyName=Plutzer Lebensmittelgroßmärkte AG Country=Germany
CompanyName=Nord-Ost-Fisch Handelsgesellschaft mbH Country=Germany
CompanyName=Formaggi Fortini s.r.l. Country=Italy
CompanyName=Norske Meierier Country=Norway
CompanyName=Bigfoot Breweries Country=United States of America
CompanyName=Svensk Sjöföda AB Country=Sweden
CompanyName=Aux joyeux ecclésiastiques Country=France
CompanyName=New England Seafood Cannery Country=United States of America
CompanyName=Leka Trading Country=Singapore
CompanyName=Lyngbysild Country=Denmark
CompanyName=Zaanse Snoepfabriek Country=Netherlands
CompanyName=Karkki Oy Country=Finland
CompanyName=G'day, Mate Country=Australia
CompanyName=Ma Maison Country=Canada
CompanyName=Pasta Buttini s.r.l. Country=Italy
CompanyName=Escargots Nouveaux Country=France
CompanyName=Gai pâturage Country=France
CompanyName=Forêts d'érables Country=Canada
