{"id":10717,"date":"2018-01-04T16:38:27","date_gmt":"2018-01-04T15:38:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/"},"modified":"2018-01-04T16:38:27","modified_gmt":"2018-01-04T15:38:27","slug":"sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/","title":{"rendered":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM"},"content":{"rendered":"

Last month, I present in the IT-Tage 2017 in Frankfurt am Main<\/a>, a session about SQL Server 2017 overview.
\nDuring my session I made a demo on one of the new string T-SQL Commands: TRIM<\/strong>.
\nMy demo was very simple but I have also 2 very good questions.<\/p>\n

Before, I write about these question, I will show you what is TRIM.
\nThis function is a replacement of RTRIM and LTRIM to delete all space character before and after a string.<\/p>\n

SELECT Name, RTRIM(LTRIM(Name)) as RLTrim_name, TRIM(Name) as Trim_name \nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n\n<\/pre>\n
\"trim01\"<\/a><\/p>\n
As you can see in the result of the query, TRIM() do the same as RTRIM(LTRIM()).<\/p>\n
But TRIM can also have a second usage and you can give a set of characters to be deleted and this use case is very useful.<\/p>\n
I made an example with this query to delete all A,n & e from my precedent query:<\/p>\n
SELECT Name, TRIM('A,n,e' FROM Name)  as Trim_name, TRIM('A,n,e, ' FROM Name)  as Trim_name2\nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n<\/pre>\n
\"trim02\"<\/a><\/p>\n
In the result in the column Trim_name, I haven\u2019t what I expected\u2026 The problem is that all name values begin or end with several space characters.
\nI you look the Trim_name2 column and his associated query, you will see that I add a space character in the special characters\u2019 list.
\nThe first interesting question was:<\/p>\n
Can I use the char(xx) to define the character to be deleted?<\/strong><\/em><\/h2>\n
The ASCII code for a Space is 32 (20 in Hex). I test my query with char(32) like this:<\/p>\n
SELECT Name, TRIM(char(32) FROM Name)  as Trim_name \nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n\n<\/pre>\n
I run the query\u2026<\/p>\n
\"trim03\"<\/a>
\nYes, it\u2019s works! I can see that my result is without space character.
\nNow, I try with another character: char(65) \u00e0 A<\/p>\n
SELECT Name, TRIM(char(32) FROM Name) as Trim_name , TRIM(char(65) FROM Name)  as Trim_name2 \nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'<\/pre>\n
\"trim04\"<\/a><\/p>\n
The result is what I expected with a deleted A at the beginning of the string.
\nMy last test is with both characters together in the same Trim function like this:<\/p>\n
SELECT Name, TRIM(char(32),char(65) FROM Name) as Trim_name \nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'<\/pre>\n
\"trim05\"<\/a><\/p>\n
As you can see, I get an error. Incorrect syntax near the keyword ‘FROM’.<\/p>\n
This way is perhaps not the good way and I try another syntax with ‘char(32),char(65)’:<\/p>\n
SELECT Name, TRIM('char(32),char(65)' FROM Name) as Trim_name\n\nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'<\/pre>\n
\"trim06\"<\/a><\/p>\n
The result is very strange. The character A at the beginning of the string is deleted but not the space character…<\/p>\n
This does not work! \ud83d\ude33<\/p>\n
As suggested by the comment of Jan (thanks to him), I use the CONCAT function with all characters that I want to delete:<\/p>\n
SELECT Name, TRIM(CONCAT(char(32), char(65)) FROM Name) as Trim_name \nFROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n<\/pre>\n
\"trim12\"<\/a>
\nUsing CONCAT work fine!<\/p>\n
Let\u2019s go to the second question
\nThe second question was:<\/p>\n
 Can I use a variable?<\/strong><\/em><\/h2>\n
My first test with a variable is very simple with the same characters set that I use in my demo:<\/p>\n
DECLARE @characters nvarchar(10);\nSET @characters= 'A,n,e, '\nSELECT Name, TRIM(@characters FROM Name)  as Trim_name FROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n<\/pre>\n
\"trim08\"<\/a>
\nIt\u2019s working fine.
\nNow, I will try with the ASCII code.<\/p>\n
First I try with one characters :<\/p>\n
DECLARE @characters nvarchar(10);\nSET @characters= char(32)\nSELECT Name, TRIM(@characters FROM Name)  as Trim_name FROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'<\/pre>\n
\"trim11\"<\/a><\/p>\n
I try with several characters.<\/p>\n
DECLARE @characters nvarchar(10);\nSET @characters= 'char(32),char(65)'\nSELECT Name, TRIM(@characters FROM Name)  as Trim_name FROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'\n<\/pre>\n
\"trim10\"<\/a>
\nAs you can see, the variable with several characters in ASCII code does not work.<\/p>\n
I also complete this test with the CONCAT function:<\/p>\n
DECLARE @characters nvarchar(10);\nSET @characters= CONCAT(char(32), char(65))\nSELECT Name, TRIM(@characters FROM Name)  as Trim_name FROM [GoT].[dbo].[character-deaths2] Where Name like '%Aegon Targaryen%'<\/pre>\n
\"trim13\"<\/a><\/p>\n
It’s working fine!<\/p>\n
Summary<\/strong><\/h2>\n
To finish, I summarize all my tests in a little report:<\/p>\n
Using CONCAT with a variable with multiple characters in ASCII code\"ok\"<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Direct characters set<\/td>\n\"ok\"<\/td>\n<\/tr>\n
Space character in ASCII code<\/td>\n\"ok\"<\/td>\n<\/tr>\n
One character in ASCII code<\/td>\n\"ok\"<\/td>\n<\/tr>\n
Multiple characters in ASCII code<\/td>\n\"nok\"<\/td>\n<\/tr>\n
Using CONCAT with multiple characters in ASCII code<\/td>\n\"ok\"<\/td>\n<\/tr>\n
Variable with several characters<\/td>\n\"ok\"<\/td>\n<\/tr>\n
Variable with one character in ASCII code<\/td>\n\"ok\"<\/td>\n<\/tr>\n
Variable with multiple characters in ASCII code<\/td>\n\"nok\"<\/td>\n<\/tr>\n
Using CONCAT with a variable with multiple characters in ASCII code<\/td>\n\"ok\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I […]<\/p>\n","protected":false},"author":15,"featured_media":10730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368,48],"tags":[49,98,51,1077],"type_dbi":[],"class_list":["post-10717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-development-performance","category-technology-survey","tag-microsoft","tag-sql","tag-sql-server","tag-sql-server-2017"],"acf":[],"yoast_head":"\nSQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM\" \/>\n<meta property=\"og:description\" content=\"Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-04T15:38:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png\" \/>\n\t<meta property=\"og:image:width\" content=\"16\" \/>\n\t<meta property=\"og:image:height\" content=\"16\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM\",\"datePublished\":\"2018-01-04T15:38:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/\"},\"wordCount\":543,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/nok-e1515083144284.png\",\"keywords\":[\"Microsoft\",\"SQL\",\"SQL Server\",\"SQL Server 2017\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Development & Performance\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/\",\"name\":\"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/nok-e1515083144284.png\",\"datePublished\":\"2018-01-04T15:38:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/nok-e1515083144284.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/nok-e1515083144284.png\",\"width\":16,\"height\":16},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM","og_description":"Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/","og_site_name":"dbi Blog","article_published_time":"2018-01-04T15:38:27+00:00","og_image":[{"width":16,"height":16,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM","datePublished":"2018-01-04T15:38:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/"},"wordCount":543,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png","keywords":["Microsoft","SQL","SQL Server","SQL Server 2017"],"articleSection":["Database Administration & Monitoring","Development & Performance","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/","name":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png","datePublished":"2018-01-04T15:38:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/nok-e1515083144284.png","width":16,"height":16},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2017-trim-not-only-a-replacement-of-rtrim-and-ltrim\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10717"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10730"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10717"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}