
LCase()
LCase() 함수는 문자열을 소문자로 변환한다.
⭐ UCase() 함수 도 살펴보자.
Access 2000에서 작동한다.
형식
LCase(text)
매개변수
text
:
변환할 문자열
예제
“CustomerName”의 텍스트를 소문자로 변환해보자.
SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers;
기본 예시
CustomerName | LowercaseCustomerName |
---|---|
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 LCase() Function
W3C School - SQL Tutorial