Concat With &
Concat With & 를 사용하면 두 개 이상의 문자열을 함께 추가할 수 있다.
Access 2000에서 작동한다.
형식
string1 & string2 & string_n
매개변수
string1, string2, string_n
:
함께 추가할 문자열
예제
3개의 열을 함께 하나의 “주소” 열로 추가해보자.
SELECT Address & ", " & PostalCode & ", " & City AS Address FROM Customers;
기본 예시
| CustomerName | Address |
|---|---|
| Alfreds Futterkiste | Obere Str. 57, 12209, Berlin |
| Ana Trujillo Emparedados y helados | Avda. de la Constitución 2222, 05021, México D.F. |
| Antonio Moreno Taquería | Mataderos 2312, 05023, México D.F. |
| Around the Horn | 120 Hanover Sq., WA1 1DP, London |
| Berglunds snabbköp | Berguvsvägen 8, S-958 22, Luleå |
| Blauer See Delikatessen | Forsterstr. 57, 68306, Mannheim |
| Blondel père et fils | 24, place Kléber, 67000, Strasbourg |
| Bólido Comidas preparadas | C/ Araquil, 67, 28023, Madrid |
| Bon app’ | 12, rue des Bouchers, 13008, Marseille |
| Bottom-Dollar Marketse | 23 Tsawassen Blvd., T2F 8M4, Tsawassen |
| B’s Beverages | Fauntleroy Circus, EC2 5NT, London |
| Cactus Comidas para llevar | Cerrito 333, 1010, Buenos Aires |
| Centro comercial Moctezuma | Sierras de Granada 9993, 05022, México D.F. |
| Chop-suey Chinese | Hauptstr. 29, 3012, Bern |
| Comércio Mineiro | Av. dos Lusíadas, 23, 05432-043, São Paulo |
| Consolidated Holdings | Berkeley Gardens 12 Brewery , WX1 6LT, London |
| Drachenblut Delikatessend | Walserweg 21, 52066, Aachen |
| Du monde entier | 67, rue des Cinquante Otages, 44000, Nantes |
| Eastern Connection | 35 King George, WX3 6FW, London |
| Ernst Handel | Kirchgasse 6, 8010, Graz |
| Familia Arquibaldo | Rua Orós, 92, 05442-030, São Paulo |
| FISSA Fabrica Inter. Salchichas S.A. | C/ Moralzarzal, 86, 28034, Madrid |
| Folies gourmandes | 184, chaussée de Tournai, 59000, Lille |
| Folk och fä HB | Åkergatan 24, S-844 67, Bräcke |
| Frankenversand | Berliner Platz 43, 80805, München |
| France restauration | 54, rue Royale, 44000, Nantes |
| Franchi S.p.A. | Via Monte Bianco 34, 10100, Torino |
| Furia Bacalhau e Frutos do Mar | Jardim das rosas n. 32, 1675, Lisboa |
| Galería del gastrónomo | Rambla de Cataluña, 23, 08022, Barcelona |
| Godos Cocina Típica | C/ Romero, 33, 41101, Sevilla |
| Gourmet Lanchonetes | Av. Brasil, 442, 04876-786, Campinas |
| Great Lakes Food Market | 2732 Baker Blvd., 97403, Eugene |
| GROSELLA-Restaurante | 5ª Ave. Los Palos Grandes, 1081, Caracas |
| Hanari Carnes | Rua do Paço, 67, 05454-876, Rio de Janeiro |
| HILARIÓN-Abastos | Carrera 22 con Ave. Carlos Soublette #8-35, 5022, San Cristóbal |
| Hungry Coyote Import Store | City Center Plaza 516 Main St., 97827, Elgin |
| Hungry Owl All-Night Grocers | 8 Johnstown Road, , Cork |
| Island Trading | Garden House Crowther Way, PO31 7PJ, Cowes |
| Königlich Essen | Maubelstr. 90, 14776, Brandenburg |
| La corne d’abondance | 67, avenue de l’Europe, 78000, Versailles |
| La maison d’Asie | 1 rue Alsace-Lorraine, 31000, Toulouse |
| Laughing Bacchus Wine Cellars | 1900 Oak St., V3F 2K1, Vancouver |
| Lazy K Kountry Store | 12 Orchestra Terrace, 99362, Walla Walla |
| Lehmanns Marktstand | Magazinweg 7, 60528, Frankfurt a.M. |
| Let’s Stop N Shop | 87 Polk St. Suite 5, 94117, San Francisco |
| LILA-Supermercado | Carrera 52 con Ave. Bolívar #65-98 Llano Largo, 3508, Barquisimeto |
| LINO-Delicateses | Ave. 5 de Mayo Porlamar, 4980, I. de Margarita |
| Lonesome Pine Restaurant | 89 Chiaroscuro Rd., 97219, Portland |
| Magazzini Alimentari Riuniti | Via Ludovico il Moro 22, 24100, Bergamo |
| Maison Dewey | Rue Joseph-Bens 532, B-1180, Bruxelles |
| Mère Paillarde | 43 rue St. Laurent, H1J 1C3, Montréal |
| Morgenstern Gesundkost | Heerstr. 22, 04179, Leipzig |
| North/South | South House 300 Queensbridge, SW7 1RZ, London |
| Océano Atlántico Ltda. | Ing. Gustavo Moncada 8585 Piso 20-A, 1010, Buenos Aires |
| Old World Delicatessen | 2743 Bering St., 99508, Anchorage |
| Ottilies Käseladen | Mehrheimerstr. 369, 50739, Köln |
| Paris spécialités | 265, boulevard Charonne, 75012, Paris |
| Pericles Comidas clásicas | Calle Dr. Jorge Cash 321, 05033, México D.F. |
| Piccolo und mehr | Geislweg 14, 5020, Salzburg |
| Princesa Isabel Vinhoss | Estrada da saúde n. 58, 1756, Lisboa |
| Que Delícia | Rua da Panificadora, 12, 02389-673, Rio de Janeiro |
| Queen Cozinha | Alameda dos Canàrios, 891, 05487-020, São Paulo |
| QUICK-Stop | Taucherstraße 10, 01307, Cunewalde |
| Rancho grande | Av. del Libertador 900, 1010, Buenos Aires |
| Rattlesnake Canyon Grocery | 2817 Milton Dr., 87110, Albuquerque |
| Reggiani Caseifici | Strada Provinciale 124, 42100, Reggio Emilia |
| Ricardo Adocicados | Av. Copacabana, 267, 02389-890, Rio de Janeiro |
| Richter Supermarkt | Grenzacherweg 237, 1203, Genève |
| Romero y tomillo | Gran Vía, 1, 28001, Madrid |
| Santé Gourmet | Erling Skakkes gate 78, 4110, Stavern |
| Save-a-lot Markets | 187 Suffolk Ln., 83720, Boise |
| Seven Seas Imports | 90 Wadhurst Rd., OX15 4NB, London |
| Simons bistro | Vinbæltet 34, 1734, København |
| Spécialités du monde | 25, rue Lauriston, 75016, Paris |
| Split Rail Beer & Ale | P.O. Box 555, 82520, Lander |
| Suprêmes délices | Boulevard Tirou, 255, B-6000, Charleroi |
| The Big Cheese | 89 Jefferson Way Suite 2, 97201, Portland |
| The Cracker Box | 55 Grizzly Peak Rd., 59801, Butte |
| Toms Spezialitäten | Luisenstr. 48, 44087, Münster |
| Tortuga Restaurante | Avda. Azteca 123, 05033, México D.F. |
| Tradição Hipermercados | Av. Inês de Castro, 414, 05634-030, São Paulo |
| Trail’s Head Gourmet Provisioners | 722 DaVinci Blvd., 98034, Kirkland |
| Vaffeljernet | Smagsløget 45, 8200, Århus |
| Victuailles en stock | 2, rue du Commerce, 69004, Lyon |
| Vins et alcools Chevalier | 59 rue de l’Abbaye, 51100, Reims |
| Die Wandernde Kuh | Adenauerallee 900, 70563, Stuttgart |
| Wartian Herkku | Torikatu 38, 90110, Oulu |
| Wellington Importadora | Rua do Mercado, 12, 08737-363, Resende |
| White Clover Markets | 305 – 14th Ave. S. Suite 3B, 98128, Seattle |
| Wilman Kala | Keskuskatu 45, 21240, Helsinki |
| Wolski | ul. Filtrowa 68, 01-012, Walla |
참고
W3C School - SQL Concat With & Function
W3C School - SQL Tutorial
공부 목적 블로그