UCase()
UCase() 함수는 문자열을 대문자로 변환한다.
⭐ Lcase() 함수 도 살펴보자.
Access 2000에서 작동한다.
형식
UCase(text)
매개변수
text
:
변환할 문자열
예제
“CustomerName”의 텍스트를 대문자로 변환해보자.
SELECT UCASE(CustomerName) AS UppercaseCustomerName FROM Customers;
기본 예시
| CustomerName | UppercaseCustomerName |
|---|---|
| Alfreds Futterkiste | ALFREDS FUTTERKISTE |
| Ana Trujillo Emparedados y helados | ANA TRUJILLO EMPAREDADOS Y HELADOS |
| Antonio Moreno Taquería | ANTONIO MORENO TAQUERÍA |
| Around the Horn | AROUND THE HORN |
| Berglunds snabbköp | BERGLUNDS SNABBKÖP |
| Blauer See Delikatessen | BLAUER SEE DELIKATESSEN |
| Blondel père et fils | BLONDEL PÈRE ET FILS |
| Bólido Comidas preparadas | BÓLIDO COMIDAS PREPARADAS |
| Bon app’ | BON APP’ |
| Bottom-Dollar Marketse | BOTTOM-DOLLAR MARKETSE |
| B’s Beverages | B’S BEVERAGES |
| Cactus Comidas para llevar | CACTUS COMIDAS PARA LLEVAR |
| Centro comercial Moctezuma | CENTRO COMERCIAL MOCTEZUMA |
| Chop-suey Chinese | CHOP-SUEY CHINESE |
| Comércio Mineiro | COMÉRCIO MINEIRO |
| Consolidated Holdings | CONSOLIDATED HOLDINGS |
| Drachenblut Delikatessend | DRACHENBLUT DELIKATESSEND |
| Du monde entier | DU MONDE ENTIER |
| Eastern Connection | EASTERN CONNECTION |
| Ernst Handel | ERNST HANDEL |
| Familia Arquibaldo | FAMILIA ARQUIBALDO |
| FISSA Fabrica Inter. Salchichas S.A. | FISSA FABRICA INTER. SALCHICHAS S.A. |
| Folies gourmandes | FOLIES GOURMANDES |
| Folk och fä HB | FOLK OCH FÄ HB |
| Frankenversand | FRANKENVERSAND |
| France restauration | FRANCE RESTAURATION |
| Franchi S.p.A. | FRANCHI S.P.A. |
| Furia Bacalhau e Frutos do Mar | FURIA BACALHAU E FRUTOS DO MAR |
| Galería del gastrónomo | GALERÍA DEL GASTRÓNOMO |
| Godos Cocina Típica | GODOS COCINA TÍPICA |
| Gourmet Lanchonetes | GOURMET LANCHONETES |
| Great Lakes Food Market | GREAT LAKES FOOD MARKET |
| GROSELLA-Restaurante | GROSELLA-RESTAURANTE |
| Hanari Carnes | HANARI CARNES |
| HILARIÓN-Abastos | HILARIÓN-ABASTOS |
| Hungry Coyote Import Store | HUNGRY COYOTE IMPORT STORE |
| Hungry Owl All-Night Grocers | HUNGRY OWL ALL-NIGHT GROCERS |
| Island Trading | ISLAND TRADING |
| Königlich Essen | KÖNIGLICH ESSEN |
| La corne d’abondance | LA CORNE D’ABONDANCE |
| La maison d’Asie | LA MAISON D’ASIE |
| Laughing Bacchus Wine Cellars | LAUGHING BACCHUS WINE CELLARS |
| Lazy K Kountry Store | LAZY K KOUNTRY STORE |
| Lehmanns Marktstand | LEHMANNS MARKTSTAND |
| Let’s Stop N Shop | LET’S STOP N SHOP |
| LILA-Supermercado | LILA-SUPERMERCADO |
| LINO-Delicateses | LINO-DELICATESES |
| Lonesome Pine Restaurant | LONESOME PINE RESTAURANT |
| Magazzini Alimentari Riuniti | MAGAZZINI ALIMENTARI RIUNITI |
| Maison Dewey | MAISON DEWEY |
| Mère Paillarde | MÈRE PAILLARDE |
| Morgenstern Gesundkost | MORGENSTERN GESUNDKOST |
| North/South | NORTH/SOUTH |
| Océano Atlántico Ltda. | OCÉANO ATLÁNTICO LTDA. |
| Old World Delicatessen | OLD WORLD DELICATESSEN |
| Ottilies Käseladen | OTTILIES KÄSELADEN |
| Paris spécialités | PARIS SPÉCIALITÉS |
| Pericles Comidas clásicas | PERICLES COMIDAS CLÁSICAS |
| Piccolo und mehr | PICCOLO UND MEHR |
| Princesa Isabel Vinhoss | PRINCESA ISABEL VINHOSS |
| Que Delícia | QUE DELÍCIA |
| Queen Cozinha | QUEEN COZINHA |
| QUICK-Stop | QUICK-STOP |
| Rancho grande | RANCHO GRANDE |
| Rattlesnake Canyon Grocery | RATTLESNAKE CANYON GROCERY |
| Reggiani Caseifici | REGGIANI CASEIFICI |
| Ricardo Adocicados | RICARDO ADOCICADOS |
| Richter Supermarkt | RICHTER SUPERMARKT |
| Romero y tomillo | ROMERO Y TOMILLO |
| Santé Gourmet | SANTÉ GOURMET |
| Save-a-lot Markets | SAVE-A-LOT MARKETS |
| Seven Seas Imports | SEVEN SEAS IMPORTS |
| Simons bistro | SIMONS BISTRO |
| Spécialités du monde | SPÉCIALITÉS DU MONDE |
| Split Rail Beer & Ale | SPLIT RAIL BEER & ALE |
| Suprêmes délices | SUPRÊMES DÉLICES |
| The Big Cheese | THE BIG CHEESE |
| The Cracker Box | THE CRACKER BOX |
| Toms Spezialitäten | TOMS SPEZIALITÄTEN |
| Tortuga Restaurante | TORTUGA RESTAURANTE |
| Tradição Hipermercados | TRADIÇÃO HIPERMERCADOS |
| Trail’s Head Gourmet Provisioners | TRAIL’S HEAD GOURMET PROVISIONERS |
| Vaffeljernet | VAFFELJERNET |
| Victuailles en stock | VICTUAILLES EN STOCK |
| Vins et alcools Chevalier | VINS ET ALCOOLS CHEVALIER |
| Die Wandernde Kuh | DIE WANDERNDE KUH |
| Wartian Herkku | WARTIAN HERKKU |
| Wellington Importadora | WELLINGTON IMPORTADORA |
| White Clover Markets | WHITE CLOVER MARKETS |
| Wilman Kala | WILMAN KALA |
| Wolski | WOLSKI |
참고
W3C School - SQL UCase() Function
W3C School - SQL Tutorial
공부 목적 블로그