{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[{"key":0,"length":13,"offset":77},{"key":1,"length":10,"offset":280}],"inlineStyleRanges":[],"text":"Для усечения концевых пробелов в SQL Server изначально имелось две функции - LTRIM и RTRIM - для усечения пробелов слева и справа соответственно. Чтобы удалить пробелы с обеих сторон строки, последовательно применялись обе функции (в примере для наглядности используется функция DATALENGTH, возвращающая число символов с учетом пробелов):","type":"unstyled","key":"68jfo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"f3c5o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"declare @s varchar(10) =' x ' -- слева 2 пробела, справа - 1","type":"blockquote","key":"fmg9c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"select datalength(@s) s, datalength(ltrim(@s)) ls,","type":"blockquote","key":"26t2o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\tdatalength(rtrim(@s)) rs, datalength(ltrim(rtrim(@s))) bs;","type":"blockquote","key":"84ud0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"24m5t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":10,"offset":0,"style":"UNDERLINE"}],"text":"s\tls\trs\tbs","type":"unstyled","key":"23h4t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4\t2\t3\t1","type":"unstyled","key":"aat27"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"1qa59"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Начиная с версии SQL Server 2017, к ним добавилась новая функция - TRIM, которая выполняет усечение с обеих сторон строки-аргумента:","type":"unstyled","key":"3v5n5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"679hs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"auk35"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"select datalength(@s) s, datalength(trim(@s)) ts;","type":"blockquote","key":"4q7sd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"cf63s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":4,"offset":0,"style":"UNDERLINE"}],"text":"s\tts","type":"unstyled","key":"crpr2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4\t1","type":"unstyled","key":"64jlm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"86uca"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Кроме того, функция TRIM приобрела дополнительный функционал - возможность усекать произвольные концевые символы. ","type":"unstyled","key":"67gil"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"При этом усекаемые символы можно задавать списком, перечисляя их в произвольном порядке. Усекаться (с обеих сторон) будут все входящие в список символы, пока не появится \"посторонний\", т.е. не входящий в список. Лучше всего продемонстрировать сказанное на примере.","type":"unstyled","key":"6vt3j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"dmk9d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"declare @s1 varchar(10)='xxaxbxy'","type":"blockquote","key":"5rq25"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"select trim('yx' from @s1) ts1,trim('x' from @s1) ts2;","type":"blockquote","key":"etil2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"ah2e8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":10,"offset":0,"style":"UNDERLINE"}],"text":"ts1\t ts2","type":"unstyled","key":"j3tk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"axb\t axbxy","type":"unstyled","key":"3qior"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"14u9e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Конечно, это еще не стандартное поведение, но уже близко. А вот что говорит стандарт относительно функции TRIM:","type":"unstyled","key":"fidih"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"bmdhm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ::= TRIM ","type":"blockquote","key":"bb4m7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ::= [ [ ] [ ] FROM ] ","type":"blockquote","key":"fn54v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ::= ","type":"blockquote","key":"39jga"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ::= LEADING | TRAILING | BOTH","type":"blockquote","key":"c6ke0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" ::= ","type":"blockquote","key":"9mh4a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"8qrs5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"u3TCh8hmlnyyWvzxPXOm"}],"entityMap":{"0":{"data":{"url":"http://www.sql-tutorial.ru/ru/book_str_space_ltrim_rtrim_functions.html"},"mutability":"MUTABLE","type":"LINK"},"1":{"data":{"url":"http://www.sql-tutorial.ru/ru/book_len_function.html"},"mutability":"MUTABLE","type":"LINK"}}},"mentions":[]}