
REVERSE()
REVERSE() 함수는 문자열을 반전시키고 결과를 반환한다.
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse에서 작동한다.
형식
REVERSE(string)
매개변수
string
:
반전시킬 문자열
예제
문자열을 반전 시키자.
SELECT REVERSE('SQL Tutorial');
기본 예시
lairotuT LQS |
CustomerName의 텍스트를 반전 시키자.
SELECT REVERSE(CustomerName) FROM Customers;
기본 예시
etsikrettuF sderflA |
sodaleh y sodaderapmE ollijurT anA |
aíreuqaT oneroM oinotnA |
nroH eht dnuorA |
pökbbans sdnulgreB |
nessetakileD eeS reualB |
slif te erèp lednolB |
sadaraperp sadimoC odilóB |
ppa noB |
estekraM ralloD-mottoB |
segareveB sB |
ravell arap sadimoC sutcaC |
amuzetcoM laicremoc ortneC |
esenihC yeus-pohC |
orieniM oicrémoC |
sgnidloH detadilosnoC |
dnessetakileD tulbnehcarD |
reitne ednom uD |
noitcennoC nretsaE |
lednaH tsnrE |
odlabiuqrA ailimaF |
.A.S sahcihclaS .retnI acirbaF ASSIF |
sednamruog seiloF |
BH äf hco kloF |
dnasrevneknarF |
noitaruatser ecnarF |
.A.p.S ihcnarF |
raM od soturF e uahlacaB airuF |
omonórtsag led aírelaG |
acipíT anicoC sodoG |
setenohcnaL temruoG |
tekraM dooF sekaL taerG |
etnaruatseR-ALLESORG |
senraC iranaH |
sotsabA-NÓIRALIH |
erotS tropmI etoyoC yrgnuH |
srecorG thgiN-llA lwO yrgnuH |
gnidarT dnalsI |
nessE hcilginöK |
ecnadnobad enroc aL |
eisAd nosiam aL |
sralleC eniW suhccaB gnihguaL |
erotS yrtnuoK K yzaL |
dnatstkraM snnamheL |
pohS N potS steL |
odacremrepuS-ALIL |
sesetacileD-ONIL |
tnaruatseR eniP emosenoL |
itinuiR iratnemilA inizzagaM |
yeweD nosiaM |
edralliaP erèM |
tsokdnuseG nretsnegroM |
htuoS/htroN |
.adtL ocitnáltA onaécO |
nessetacileD dlroW dlO |
nedalesäK seilittO |
sétilaicéps siraP |
sacisálc sadimoC selcireP |
rhem dnu olocciP |
ssohniV lebasI asecnirP |
aicíleD euQ |
ahnizoC neeuQ |
potS-KCIUQ |
ednarg ohcnaR |
yrecorG noynaC ekanselttaR |
icifiesaC inaiggeR |
sodacicodA odraciR |
tkramrepuS rethciR |
ollimot y oremoR |
temruoG étnaS |
stekraM tol-a-evaS |
stropmI saeS neveS |
ortsib snomiS |
ednom ud sétilaicépS |
elA & reeB liaR tilpS |
seciléd semêrpuS |
eseehC giB ehT |
xoB rekcarC ehT |
netätilaizepS smoT |
etnaruatseR agutroT |
sodacremrepiH oãçidarT |
srenoisivorP temruoG daeH sliarT |
tenrejleffaV |
kcots ne selliautciV |
reilavehC sloocla te sniV |
huK ednrednaW eiD |
ukkreH naitraW |
arodatropmI notgnilleW |
stekraM revolC etihW |
alaK namliW |
iksloW |
참고
W3C School - SQL REVERSE() Function
W3C School - SQL Tutorial