LOWER()
LOWER() 함수는 문자열을 소문자로 변환한다.
⭐ UPPER() 함수도 같이 알아보자.
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse에서 작동한다.
형식
LOWER(text)
매개변수
text
:
변환할 문자열
예제
텍스트를 소문자로 변환하자.
SELECT LOWER('SQL Tutorial is FUN!');
기본 예시
| sql tutorial is fun! |
“CustomerName”의 텍스트를 소문자로 변환하자.
SELECT LOWER(CustomerName) AS LowercaseCustomerName FROM Customers;
기본 예시
| LowercaseCustomerName |
|---|
| alfreds futterkiste |
| ana trujillo emparedados y helados |
| antonio moreno taquería |
| around the horn |
| berglunds snabbköp |
| blauer see delikatessen |
| blondel père et fils |
| bólido comidas preparadas |
| bon app |
| bottom-dollar marketse |
| bs beverages |
| cactus comidas para llevar |
| centro comercial moctezuma |
| chop-suey chinese |
| comércio mineiro |
| consolidated holdings |
| drachenblut delikatessend |
| du monde entier |
| eastern connection |
| ernst handel |
| familia arquibaldo |
| fissa fabrica inter. salchichas s.a. |
| folies gourmandes |
| folk och fä hb |
| frankenversand |
| france restauration |
| franchi s.p.a. |
| furia bacalhau e frutos do mar |
| galería del gastrónomo |
| godos cocina típica |
| gourmet lanchonetes |
| great lakes food market |
| grosella-restaurante |
| hanari carnes |
| hilarión-abastos |
| hungry coyote import store |
| hungry owl all-night grocers |
| island trading |
| königlich essen |
| la corne dabondance |
| la maison dasie |
| laughing bacchus wine cellars |
| lazy k kountry store |
| lehmanns marktstand |
| lets stop n shop |
| lila-supermercado |
| lino-delicateses |
| lonesome pine restaurant |
| magazzini alimentari riuniti |
| maison dewey |
| mère paillarde |
| morgenstern gesundkost |
| north/south |
| océano atlántico ltda. |
| old world delicatessen |
| ottilies käseladen |
| paris spécialités |
| pericles comidas clásicas |
| piccolo und mehr |
| princesa isabel vinhoss |
| que delícia |
| queen cozinha |
| quick-stop |
| rancho grande |
| rattlesnake canyon grocery |
| reggiani caseifici |
| ricardo adocicados |
| richter supermarkt |
| romero y tomillo |
| santé gourmet |
| save-a-lot markets |
| seven seas imports |
| simons bistro |
| spécialités du monde |
| split rail beer & ale |
| suprêmes délices |
| the big cheese |
| the cracker box |
| toms spezialitäten |
| tortuga restaurante |
| tradição hipermercados |
| trails head gourmet provisioners |
| vaffeljernet |
| victuailles en stock |
| vins et alcools chevalier |
| die wandernde kuh |
| wartian herkku |
| wellington importadora |
| white clover markets |
| wilman kala |
| wolski |
참고
W3C School - SQL LOWER() Function
W3C School - SQL Tutorial
공부 목적 블로그