[MSSQL] 문자열 자르기

구분자로 자르기
문자열: ‘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 [나는 개발자다]

Comments (117)

  1. Pingback: Slotxo

  2. Pingback: mơ thấy con cá đánh đề con gì

  3. Pingback: ตู้แปลภาษา

  4. Pingback: DevOps as a Service

  5. Pingback: mơ thấy bơi trong nước

  6. Pingback: mơ thấy gấu đánh con gì

  7. Pingback: kim ngưu và ma kết

  8. Pingback: xếp hạng các chòm sao

  9. Pingback: cây phong thuỷ phòng làm việc

  10. Pingback: giải mã ác mộng

  11. Pingback: mơ thấy mất xe đạp

  12. Pingback: how to change eu driving license for uk

  13. Pingback: Cornhole

  14. Pingback: nằm mơ thấy bắt được cá lóc

  15. Pingback: mơ bị sét đánh

  16. Pingback: nằm mơ thấy mình thắp hương

  17. Pingback: mơ thấy ăn ổi

  18. Pingback: Regression testing

  19. Pingback: red bull cases wholesale

  20. Pingback: mơ thấy cầu vồng

  21. Pingback: 만화보는사이트

  22. Pingback: slowed reverb sad songs

  23. Pingback: cbd for anxiety

  24. Pingback: cách tỏ tình lãng mạn

  25. Pingback: mơ bắt được cá trê

  26. Pingback: sự tôn trọng trong tình yêu

  27. Pingback: mơ thấy gái đánh con gì

  28. Pingback: Oxycontin For Sale Online

  29. Pingback: replika rolex

  30. Pingback: nbc bank

  31. Pingback: w88

  32. Pingback: relx infinity

  33. Pingback: Sexual harassment (disambiguation)

  34. Pingback: buy dilaudid iv online

  35. Pingback: W88casino

  36. Pingback: sa game

  37. Pingback: dịch vụ marketing tổng thể

  38. Pingback: W88casino

  39. Pingback: thuốc khớp malaysia

  40. Pingback: microsoft exchange hosting fiyat

  41. 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

  42. Pingback: microsoft exchange mail

  43. Pingback: kurumsal it danışmanlığı

  44. Pingback: microsoft exchange mail

  45. Pingback: cheap cvv dumps

  46. Pingback: W88

  47. Pingback: bilişim danışmanlığı

  48. Pingback: Sunucu Teknik Destek

  49. Pingback: internet bağlantısı kopuyor

  50. Pingback: exchange online fiyat

  51. Pingback: HP Server Teknik Destek

  52. 응답

    canadian discount pharmacies
    natural substitute for viagra canada pharmacies online viagra no prescription substitute viagra [url=https://myspace.com/tvshake52]viagra online canada pharmacy[/url] buy viagra online uk canadian drugs without a prescription canada online pharmacy viagra pills from canada [url=https://www.storeboard.com/blogs/go-green/want-to-really-feel-better-follow-these-essential-nourishment-tips/4981678]viagra canadian[/url]
    viagra stories buying cialis in canada canadian pharmacy viagra online viagra brand for sale [url=http://www.v0795.com/home.php?mod=space&uid=253456]natural substitute for viagra[/url]

  53. 응답

    constantly i used to read smaller articles or reviews that also
    clear their motive, and that is also happening with this post which I am reading here.

  54. 응답

    I am no longer certain where you are getting your information, however great topic.
    I must spend some time studying more or understanding more.
    Thanks for great info I used to be looking for this info for my mission.

  55. 응답

    Do you have a spam problem on this site; I also am a blogger, and I was wondering your situation; many of us have developed some nice methods and we are looking to exchange techniques with others, please shoot me an email if interested.

  56. 응답

    I’m really enjoying the design and layout of your site. It’s a
    very easy on the eyes which makes it much more pleasant for me to
    come here and visit more often. Did you hire out a designer
    to create your theme? Exceptional work!

  57. 응답

    Hey there I am so happy I found your site, I really found
    you by mistake, while I was researching on Aol
    for something else, Regardless I am here now and would just like to say
    thank you for a incredible post and a all round thrilling blog (I also love the theme/design),
    I don’t have time to read it all at the moment but I have book-marked it and also added in your RSS feeds, so when I have
    time I will be back to read a great deal more, Please do keep up the awesome work.

  58. 응답

    Greetings from California! I’m bored to tears at work
    so I decided to browse your website on my iphone during lunch
    break. I love the knowledge you provide here and can’t wait to take a look when I get home.
    I’m shocked at how fast your blog loaded on my phone ..
    I’m not even using WIFI, just 3G .. Anyways, awesome site!

  59. 응답

    I loved as much as you’ll receive carried out right here.
    The sketch is attractive, your authored
    material stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following.
    unwell unquestionably come further formerly again as
    exactly the same nearly very often inside case you shield this hike.

  60. 응답

    Hello are using WordPress for your site platform?
    I’m new to the blog world but I’m trying to get started and create my own. Do you
    require any html coding expertise to make your own blog?
    Any help would be really appreciated! ps4 https://j.mp/3z5HwTp ps4 games

  61. Pingback: Temp Email

  62. 응답
  63. 응답

    I do not even understand how I stopped up here, however I thought this submit
    was great. I don’t know who you are however certainly you’re going to a well-known blogger in the event
    you aren’t already. Cheers!

  64. Pingback: meritroyalbet

  65. Pingback: meritroyalbet

  66. Pingback: madridbet

  67. Pingback: meritroyalbet

  68. Pingback: makrobet

  69. Pingback: makrobet

  70. Pingback: slot siteleri

  71. Pingback: arzbet

  72. Pingback: arzbet

  73. Pingback: eurocasino giriş

  74. Pingback: kronosslot

  75. Pingback: meritking

  76. Pingback: elexusbet

  77. 응답

    Hi there just wanted to give you a brief heads up and let you know a few of the images aren’t loading properly. I’m not sure why but I think its a linking issue. I’ve tried it in two different web browsers and both show the same outcome.

  78. 응답

    Nice post. I learn something totally new and challenging on sites I stumbleupon every day. It will always be useful to read articles from other authors and practice something from other web sites. My web-site

  79. Pingback: aspercasino giriş

  80. Pingback: meritroyalbet

  81. Pingback: kronosslot

  82. Pingback: eurocasino giriş

  83. Embano

    응답

    Каждый день миллионы людей ищут фильмы онлайн, и никто не хочет усложнять себе жизнь – и вы наверняка один из них! А раз так, то ivi – это именно тот ресурс, который вам нужен. От лучших кинолент в HD-качестве вас отделяет буквально один клик. Мы не просто освобождаем от необходимости идти в кинотеатр или изучать программу телепередач – у посетителей нашего ресурса гораздо больше возможностей. Эти два случая, судя по всему, отличаются от упомянутых раньше, потому что сложно понять, чем это полезно для баранов или мужчин с точки зрения эволюции. Как предрасположенность к однополым связям может передаваться по наследству, если нет потомства? По ее словам, опыт наших мам научил ее, что “абсолютно все возможно в жизни”. И, как она вспоминает, “было круто” иметь мам-лесбиянок, когда она училась в университете. “Я всегда чувствовала сильную эмоциональную связь с членами ЛГБТ-сообщества. Каминг-аут моей сестры Грэйс в качестве лесбиянки в 17 лет стал поворотным пунктом в моем понимании их проблем”, – заявляла она. https://golf-wiki.win/index.php/Порно_видео_смотреть Брутальная сексуальная пара страстно трахается Страстный секс с молодой сексуальной сучкой в разных позах Krissie любит оральные ласки в позе 69 и страстный секс Молодая рыженькая парочка занимаются сексом Парень дочери застал силиконовую мачеху за дрочкой и пригласил ее на секс втроем Сексапильная страстная блондиночка ебется с прислугой Страстная чертовка массажистка трахнула клиента на массаже Страстные сексуальные лесбиянки устроили групповуху Красивый секс темноволосой куртизанки с напарником Страстный секс парочки на кухне Сексуальная страстная блондиночка ебется с покупателем дома Страстная похотливая сучка замутила секс втроем на улице Помог силиконовой мачехе натянуть колготки на огромную жопу и поимел ее на кровати Молодая рыженькая парочка занимаются сексом Дамочка еще очень молода и страстна, но парень ведь еще моложе, что ее ничуть не смущает и она показывает ему, что такое настоящий взрослый секс

  84. 응답

    If some one wishes expert view about blogging then i propose him/her to visit this blog, Keep up the fastidious work.

  85. 응답

    There are certainly a lot of details like that to take into consideration. That is a great point to bring up. I offer the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in honest good faith. I don?t know if best practices have emerged around things like that, but I am sure that your job is clearly identified as a fair game. Both boys and girls feel the impact of just a moment?s pleasure, for the rest of their lives.

  86. 응답

    An impressive share, I just given this onto a colleague who was doing a little analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If possible, as you become expertise, would you mind updating your blog with more details? It is highly helpful for me. Big thumb up for this blog post!

  87. Pingback: fuck google

  88. 응답

    This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want?HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

Leave a comment

이메일 주소는 공개되지 않습니다.