구분자로 자르기
문자열: ‘ABC\DE\FGH’
— ‘\’ 기준으로 앞에서 자르기
SELECT LEFT(‘ABC\DE\FGH’, CHARINDEX(‘\’, ‘ABC\DE\FGH’)-1);
결과: ABC
— ‘\’ 기준으로 중간에서 자르기
SELECT SUBSTRING(‘ABC\DE\FGH’, CHARINDEX(‘\’, ‘ABC\DE\FGH’)+1, LEN(‘ABC\DE\FGH’)-CHARINDEX(‘\’, ‘ABC\DE\FGH’)-CHARINDEX(‘\’, REVERSE(‘ABC\DE\FGH’)));
결과: DE
— ‘\’ 기준으로 뒤에서 자르기
SELECT RIGHT(‘ABC\DE\FGH’,CHARINDEX(‘\’, REVERSE(‘ABC\DE\FGH’))-1);
결과: FGH
길이로 자르기
문자열: ‘ABCDEFGH’
— 앞에서 자르기
SELECT LEFT(‘ABCDEFGH’, 3);
결과: ABC
— 중간에서 자르기
SELECT SUBSTRING(‘ABCDEFGH’, 4, 2);
결과: DE
— 뒤에서 자르기
SELECT RIGHT(‘ABCDEFGH’, 3);
결과: FGH
출처: http://developerking.tistory.com/1 [나는 개발자다]
Pingback: Slotxo
Pingback: mơ thấy con cá đánh đề con gì
Pingback: ตู้แปลภาษา
Pingback: DevOps as a Service
Pingback: mơ thấy bơi trong nước
Pingback: mơ thấy gấu đánh con gì
Pingback: kim ngưu và ma kết
Pingback: xếp hạng các chòm sao
Pingback: cây phong thuỷ phòng làm việc
Pingback: giải mã ác mộng
Pingback: mơ thấy mất xe đạp
Pingback: how to change eu driving license for uk
Pingback: Cornhole
Pingback: nằm mơ thấy bắt được cá lóc
Pingback: mơ bị sét đánh
Pingback: nằm mơ thấy mình thắp hương
Pingback: mơ thấy ăn ổi
Pingback: Regression testing
Pingback: red bull cases wholesale
Pingback: mơ thấy cầu vồng
Pingback: 만화보는사이트
Pingback: slowed reverb sad songs
Pingback: cbd for anxiety
Pingback: cách tỏ tình lãng mạn
Pingback: mơ bắt được cá trê
Pingback: sự tôn trọng trong tình yêu
Pingback: mơ thấy gái đánh con gì
Pingback: Oxycontin For Sale Online
Pingback: replika rolex
Pingback: nbc bank
Pingback: w88
Pingback: relx infinity
Pingback: Sexual harassment (disambiguation)
Pingback: buy dilaudid iv online
Pingback: W88casino
Pingback: sa game
Pingback: dịch vụ marketing tổng thể
Pingback: W88casino
Pingback: thuốc khớp malaysia
Pingback: microsoft exchange hosting fiyat
Pingback: bulut depolama,bulut,yedekleme,ücretsiz bulut hizmeti,en iyi bulut şirketi,en iyi bulut firması,bulut depolama fiyatı,en ucuz bulut depolama,en iyi bulut depolama hangisi,en iyi bulut depolama,bulut arşivleme sistemi,online yedekleme,bulut yedekleme
Pingback: microsoft exchange mail
Pingback: kurumsal it danışmanlığı
Pingback: microsoft exchange mail
Pingback: cheap cvv dumps
Pingback: W88
Pingback: bilişim danışmanlığı
Pingback: Sunucu Teknik Destek
Pingback: internet bağlantısı kopuyor
Pingback: exchange online fiyat
Pingback: HP Server Teknik Destek
Allen Pare
Casting
Lovie Ozga
JefferyOpips
are web hosting
t.co
t.co
scoliosis surgery but
http://bit.ly/3kKtL7d
http://j.mp/3kKtL7d
bit.ly
bitly.com
haibiaw
cialis without a prescription
scoliosis surgery there
Speeddy
piseata
isofova
loosymn
app.gumroad.com
the quest bars
j.mp
http://www.iherb.com/
j.mp
j.mp
Lasix
PaydayFum
oppossy
gabapentin 300 mg
Pingback: Temp Email
crearne
Cishose
Sex fuckfest porn and drugs
uefa canlı izle
j.mp
ps4 games but
their ps4 games
Dinkdasia
holorma
Viagra
no rx prednisone
Pingback: meritroyalbet
Pingback: meritroyalbet
Pingback: madridbet
Pingback: meritroyalbet
Pingback: makrobet
Pingback: makrobet
Pingback: slot siteleri
Pingback: arzbet
Pingback: arzbet
Pingback: eurocasino giriş
Pingback: kronosslot
Pingback: meritking
Pingback: elexusbet
카지노사이트
바카라사이트
Pingback: aspercasino giriş
Pingback: meritroyalbet
Pingback: kronosslot
Pingback: eurocasino giriş
Embano
is asmr
sex fuck
נערות ליווי בחיפה
Pingback: fuck google
what is artificial grass?
Pingback: fuck Google
Notfall Elektriker
mm88warp
mm88warp
สล็อตออนไลน์
Floocop
Cayla Lyons
browning rifles for sale
beretta silver pigeon for sale
best porn
Buy Percocet Rx
Buy Percocet online
kimber polished revolver
jetsZers
jetsZers
jetsZers
ליווי בחיפה
נערות ליווי בחיפה
נערות ליווי בנשר
נערות ליווי בנשר
jetsZers
Pingback: chilf porn
온라인크랩스
bodrum escort
anti kasan kahpe evladıyım
child porn
childporn
childporn
diadneni
aa-12 shotgun
cheetah cat for sale
diadneni
springfield 911 for sale
century arms
leer más información
Halay
得到我
इसे ऑनलाइन पढ़ें
網上免費的東西
MARQ® Driver Performance Edition
ألعاب القمار
Pingback: Netflix bez VPN
Pingback: projectio
Pingback: moskva psiholog online
Pingback: psy online
Pingback: bahis siteleri
Pingback: DPTPtNqS
Pingback: qQ8KZZE6
Pingback: D6tuzANh
Pingback: http://bit.ly/odna-film
Pingback: https://ria.ru/20100906/272903623.html
Pingback: SHKALA TONOV
Pingback: Øêàëà òîíîâ
Pingback: russianmanagement.com
Pingback: chelovek-iz-90-h
Pingback: 3Hk12Bl
Pingback: 3NOZC44
Pingback: 01211
Pingback: tor-lyubov-i-grom
Pingback: film-tor-2022
Pingback: hd-tor-2022
Pingback: hdorg2.ru
Pingback: Psikholog
Pingback: netstate.ru
Pingback: https://bit.ly/psikholog-muzhchina-onlayn
Pingback: 3outlined
Pingback: Link
Pingback: tor-lyubov-i-grom.ru
Pingback: psy
Pingback: chelovek soznaniye mozg