{"id":20937,"date":"2025-04-01T05:52:38","date_gmt":"2025-04-01T05:52:38","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=20937"},"modified":"2025-04-01T06:04:08","modified_gmt":"2025-04-01T06:04:08","slug":"sql-string-functions","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/","title":{"rendered":"Essential SQL String Functions You Should Know"},"content":{"rendered":"\n<p><strong>Summary:<\/strong> SQL string functions simplify text manipulation in databases. From CONCAT() to REPLACE(), these functions clean, extract, and format text seamlessly. Learning them enhances data processing skills, making SQL queries more efficient. Explore data science courses by Pickl.AI to master SQL and advance your career in data analytics.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#CONCAT_%E2%80%93_Combine_Multiple_Strings\" >CONCAT() \u2013 Combine Multiple Strings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#CHAR_LENGTH_CHARACTER_LENGTH\" >CHAR_LENGTH() \/ CHARACTER_LENGTH()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#LENGTH_%E2%80%93_Get_the_Byte_Length_of_a_String\" >LENGTH() \u2013 Get the Byte Length of a String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#REPLACE_%E2%80%93_Substitute_Text_Within_a_String\" >REPLACE() \u2013 Substitute Text Within a String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#SUBSTRING_SUBSTR_%E2%80%93_Extract_Part_of_a_String\" >SUBSTRING() \/ SUBSTR() \u2013 Extract Part of a String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#LEFT_and_RIGHT_%E2%80%93_Retrieve_Characters_from_a_String\" >LEFT() and RIGHT() \u2013 Retrieve Characters from a String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#INSTR_%E2%80%93_Find_the_Position_of_a_Word\" >INSTR() \u2013 Find the Position of a Word<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#TRIM_%E2%80%93_Remove_Extra_Spaces\" >TRIM() \u2013 Remove Extra Spaces<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#REVERSE_%E2%80%93_Flip_the_Text\" >REVERSE() \u2013 Flip the Text<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#ASCII_%E2%80%93_Get_the_ASCII_Code_of_a_Character\" >ASCII() \u2013 Get the ASCII Code of a Character<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#CONCAT_WS_%E2%80%93_Concatenate_Strings_with_a_Separator\" >CONCAT_WS() \u2013 Concatenate Strings with a Separator<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#FIND_IN_SET_%E2%80%93_Search_for_a_Value_in_a_List\" >FIND_IN_SET() \u2013 Search for a Value in a List<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#FORMAT_%E2%80%93_Format_Numbers\" >FORMAT() \u2013 Format Numbers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#LPAD_%E2%80%93_Add_Padding_to_the_Left\" >LPAD() \u2013 Add Padding to the Left<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#REPEAT_%E2%80%93_Repeat_a_String_Multiple_Times\" >REPEAT() \u2013 Repeat a String Multiple Times<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#STRCMP_%E2%80%93_Compare_Two_Strings\" >STRCMP() \u2013 Compare Two Strings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#UPPER_and_LOWER_%E2%80%93_Convert_Case\" >UPPER() and LOWER() \u2013 Convert Case<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#RTRIM_%E2%80%93_Remove_Trailing_Spaces\" >RTRIM() \u2013 Remove Trailing Spaces<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#SPACE_%E2%80%93_Generate_a_String_of_Spaces\" >SPACE() \u2013 Generate a String of Spaces<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#RPAD_%E2%80%93_Add_Padding_to_the_Right\" >RPAD() \u2013 Add Padding to the Right<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#MID_%E2%80%93_Extract_a_Portion_of_a_String\" >MID() \u2013 Extract a Portion of a String<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#POSITION_%E2%80%93_Find_the_Position_of_a_Substring\" >POSITION() \u2013 Find the Position of a Substring<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#LOCATE_%E2%80%93_Find_the_First_Occurrence_of_a_Substring\" >LOCATE() \u2013 Find the First Occurrence of a Substring<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#In_Closing\" >In Closing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#What_are_SQL_String_Functions\" >What are SQL String Functions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#How_do_SQL_String_Functions_improve_data_manipulation\" >How do SQL String Functions improve data manipulation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#Why_should_I_learn_SQL_string_functions\" >Why should I learn SQL string functions?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ever tried organising messy text data in <a href=\"https:\/\/pickl.ai\/blog\/introduction-to-sql-for-data-science\/\">SQL<\/a>? That\u2019s where SQL string functions come to the rescue! These handy tools help you clean, modify, and extract text effortlessly\u2014just like a digital spellchecker for your database. Whether you want to combine names, find keywords, or remove extra spaces, these functions make your life easier.<\/p>\n\n\n\n<p>In this blog, we\u2019ll break down some must-know SQL string functions with simple examples. By the end, you\u2019ll know how to handle text data like a pro\u2014even if you\u2019re new to SQL. Ready to level up your data game? Let\u2019s dive in!<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL string functions help manipulate, extract, and clean text data efficiently.<\/li>\n\n\n\n<li>Functions like CONCAT(), REPLACE(), and SUBSTRING() improve data handling.<\/li>\n\n\n\n<li>TRIM() and LENGTH() optimise database text formatting and storage.<\/li>\n\n\n\n<li>These functions are crucial for database management and reporting.<\/li>\n\n\n\n<li>Learn SQL through Pickl.AI\u2019s data science courses to enhance your expertise.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"concat-combine-multiple-strings\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CONCAT_%E2%80%93_Combine_Multiple_Strings\"><\/span><strong>CONCAT() \u2013 Combine Multiple Strings<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The CONCAT() function allows you to join two or more strings together. This is useful when merging names, addresses, or any other text-based <a href=\"https:\/\/pickl.ai\/blog\/difference-between-data-and-information\/\">data<\/a>.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfnYlAkXew0_GcFcV2LyM4hSaFiqAHhVEUV9YsoFmJnYZv6fJMFZetVn_fJ8jnsC1JC_DOAAyM0tUSSu_X4dnz_GvSln0iotMF_sn1wDnyBMCtN9W6aOYEYlBMxZ2IegZ3TeE6FGg?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"The CONCAT() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdqBwAVFlALlH_zjw9B7a-izRYSPmrYjnVVeXAraLCbeFHx4fndjW52ZOdyThhG0vS1L3J9geD23pWRc61o-o3zgH3NtHTr-k24v65edeQgxxgEKJjQ_pFENQSEQz1CKHcEbKH3EQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"\"\/><\/figure>\n\n\n\n<h2 id=\"char_length-character_length\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CHAR_LENGTH_CHARACTER_LENGTH\"><\/span><strong>CHAR_LENGTH() \/ CHARACTER_LENGTH()<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Both CHAR_LENGTH() and CHARACTER_LENGTH() return the number of characters in a string, including spaces.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXciWJAPEZ2Svnta2Y0-is4OOCrTZxbfdKO8MByANEgXiTPFcpKMTEYPhmuPEGsPJNShMMNFQZm0bATZp-RxuO0ZRLinD5HsA0WmURF2hCPksk-mJ_jpFyKsRoyEd2iWD4rJ8UPhKw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" CHAR_LENGTH() and CHARACTER_LENGTH() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfVT-zCTbZ3idEDlfEtDFmb5md7aPpJVw7rtwm5fE8RshUpeZfYPSc6To2MbDyKERFhG9rWUrY_5uLDyOoR92mh6R1D2UVionBI2y_DfWAhm_b7w51sOxiNKoWwsvrCdSWCOKsPmw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Counts characters in &quot;SQL Functions&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"length-get-the-byte-length-of-a-string\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"LENGTH_%E2%80%93_Get_the_Byte_Length_of_a_String\"><\/span><strong>LENGTH() \u2013 Get the Byte Length of a String<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The LENGTH() function counts the number of bytes in a string rather than characters.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcfX_3FLM1nn3bmuJRJU7BK4R8K8_f66AYYEoXrRLn-ebeUXxlpoYmSrIzY30RiPjjiroQe3gLv4ASXmDfYeH2jsb786x15jFEX1ruFb19Ag0XRtZDovv0l06QMaSzpqa8e6tDG?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"The LENGTH() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeU5mf5oT_JbCeIIe61DaWpIYc2GmzeuO8QPpkZa5G5I4LaDDLba-9KsfyIIUqJWRJsVM85UJsvOB5j_vtzuaZnJ8Zj-1ymYSH_vl1vR8y2hTzb3_hWEQM_wQsIuzGmxyZy_Git?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Returns byte length of &quot;SQL&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"replace-substitute-text-within-a-string\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"REPLACE_%E2%80%93_Substitute_Text_Within_a_String\"><\/span><strong>REPLACE() \u2013 Substitute Text Within a String<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The REPLACE() function allows you to replace specific words or characters within a string.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd7rKYHE-I3-h3aM4ukzqpL62WoYkrUPJkyomjiHrvpZhQykcXmW5pLAHKfL5t46USxdSwkSAQgdoY9c9d4v8e5PyTzaYFdAOQnpBWdySocbCRISLtLrKk7i4mUXhlDzFXpHzP2?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of The REPLACE() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdgX6SFK1iRhBZ6FpegAMm8XYBjhCFVs25B6jzbX1e8XBZN8-cN2xcnTVfTNCqepu3bgt5To3G5fdPulzGDeXFbRMkJwKc584It6zvExjUCO20tXwPYJXwQ615Dtfv9DfescorJVQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Replaces &quot;Python&quot; with &quot;SQL&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"substring-substr-extract-part-of-a-string\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SUBSTRING_SUBSTR_%E2%80%93_Extract_Part_of_a_String\"><\/span><strong>SUBSTRING() \/ SUBSTR() \u2013 Extract Part of a String<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>These functions extract a portion of a string based on position and length.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcqf9l5HkeOWLspacZQjiKgjeG7T5hfCYTimcfG0MNDMZozsMK_K6QujV9tHZul62mwMPme7HwiLsdQEgg_1drVo1sWIvgeRgVdd-ulyp5FRaFFo2mfOAJT0iLVYtZ9a3EPfdCg8Q?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of SUBSTRING() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfGs2P0TRIYGmTna4wZN3Qfp_ubhUvnNZirS3Bccy6qmbamnldgp69ejO4jgZsbcEW9nE2NNLqh7lgYp20rOVAf0G8UQad9D1w7FfL8H_1eRBCZJ1xXz2_o_i9BTTr8M8wghV4TVg?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Extracts &quot;Database&quot; from text.\"\/><\/figure>\n\n\n\n<h2 id=\"left-and-right-retrieve-characters-from-a-string\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"LEFT_and_RIGHT_%E2%80%93_Retrieve_Characters_from_a_String\"><\/span><strong>LEFT() and RIGHT() \u2013 Retrieve Characters from a String<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LEFT() extracts a specific number of characters from the beginning of a string.<br><\/li>\n\n\n\n<li>RIGHT() extracts characters from the end.<br><\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfUGzwzkTuO0WUpvzhlpIvZKtadRY-zAmmZsJomSAkfKF8EnZungCPKn0j29ymbo9eRv62r14d3Dg-imZVi1kD0H9zYuHsOPhm-wlBCM-TqCvUBRGBPeNtNgGREMBkhjgtTVk0CcA?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of LEFT() and RIGHT() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcxof5BTgvFrkSSlnj28mCuM-5uePu3dGzcdmEJafhRWqJ_kO9O2I_HhT2itXbQWkJettyug72Y3gRgdt8wXzUoKqjcoS7Bo2MFU0ZodraMcTvQYqAh0BFIcv6pHTKACNv2PeRCzQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Extracts first and last four letters.\"\/><\/figure>\n\n\n\n<h2 id=\"instr-find-the-position-of-a-word\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"INSTR_%E2%80%93_Find_the_Position_of_a_Word\"><\/span><strong>INSTR() \u2013 Find the Position of a Word<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The INSTR() function tells you where a specific word or letter appears in a string.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdulbeErb3nq_gmDBteDJ1fcp7NES6zYF4sOWkRzoxVSabsiLPMtNkI00HwvJKiCjM6sQERbmN7Re1-LraDbFLBlI1ap90cWDRFz35WofkLN48SjCphsj5LDaqQfVy2gcjGUuQD4Q?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Example of INSTR() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeOv6rcXY0pgQc-61HNhoje3t-wEOYgUIjO9YGGMJq5rBFQWeJov92N3Ac-MM_vh9VZKMXW1Ftc3CdIS63MIKO_xhS_iWqqDrlMSEl99dsXc97ZCQaP8kmEFAljoUUiMMXjNiMxQQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Finds &quot;Science&quot; in &quot;Data Science&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"trim-remove-extra-spaces\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TRIM_%E2%80%93_Remove_Extra_Spaces\"><\/span><strong>TRIM() \u2013 Remove Extra Spaces<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The TRIM() function removes spaces from a string&#8217;s beginning and end.<\/p>\n\n\n\n<p>Example:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdkLGvXnADmJob3UsEwhKeenkLTobFKDuf_0nScIf64zEaHAPZykYBIS5f8kQ4HhAQATUAbAst2Vrh7UpN-My8DgvWj-4OS5xsPeKf49BMD6tgcZzXa5YU7GSy8KJ-Ut2ebUdeZWQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of TRIM() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeEzrSVwmDbCPeUlBSL1cDO2BWG-BrNEAORNzHknLorMfc6MsbuaczfarujgzOpeSloQugatMXF-CfuZyLDHQkFmYzinGE37YUPo7WC4omTzWPxvn_ii8F4sL9dJz4xjynjtMwH?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Removes extra spaces.\"\/><\/figure>\n\n\n\n<h2 id=\"reverse-flip-the-text\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"REVERSE_%E2%80%93_Flip_the_Text\"><\/span><strong>REVERSE() \u2013 Flip the Text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The REVERSE() function reverses the characters in a string.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcItYvphGcXsCAI933OkPWHxB7aG86Vjh7qZXOTT7Ro59wGZvbhWpazTrKesNb12Pek-ofnaX870XniH9CzLUaHlISNRFQrKAUkIfXJ4aT1NMxk5LcFM031-7rxpMcGjdgr1-4s1g?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of REVERSE() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeFbikOW1wrIiULAksS5dg1ZfJPEB89rwowbzpIm3kHXnxw0yZ_64p_IOmP4hlGFIgjQh-EZKphlhUeJWk-WI3mfcAHvXn7D3ELWWpGd2IYvD_OnkpoJUi8mMsLH5KoJUmcRxCeMg?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Reverses &quot;Hello&quot; to &quot;olleH&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"ascii-get-the-ascii-code-of-a-character\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ASCII_%E2%80%93_Get_the_ASCII_Code_of_a_Character\"><\/span><strong>ASCII() \u2013 Get the ASCII Code of a Character<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The ASCII() function returns the numeric ASCII code of the first character in a string.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe18eyOn2h0gMrkQ5NRLG4EvFs5oTM0HwtBSippysaSOg11ehVQNQfGS7g44hZqQ0OyHhaOWrZoepcMVJcgqAXIyff5Lo7PqgwS_X8NuxNx3joLwPSXSuYXlgEotrTP2dQXv-_4jQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of ASCII() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcmPeCbsuLg6cmxSku8P5EroVqygMyEz0OVFGGCfD17yZvIC6MQbKr3ug_Dr6sfkKWquwlVs7WxJ373nIy-KtyaHz7Mxk2kajcH1hCxTnMf4koS9X-R4ghHs2-oc0rpfu15MvgtMQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Returns ASCII value of &quot;A&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"concat_ws-concatenate-strings-with-a-separator\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CONCAT_WS_%E2%80%93_Concatenate_Strings_with_a_Separator\"><\/span><strong>CONCAT_WS() \u2013 Concatenate Strings with a Separator<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>CONCAT_WS() works like CONCAT() but allows you to specify a <a href=\"https:\/\/docs.teradata.com\/r\/Enterprise_IntelliFlex_VMware\/SQL-Fundamentals\/Basic-SQL-Syntax\/Separators\" rel=\"nofollow\">separator<\/a>.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcWKFpgV2vLnJ907d5BKJasXsluVqu1vuZolGkmYJOkJBfRYSJR9dv2I0-tz9Ew3Mfcjq00vyJbtfeUxEMgyqWi9HdNn2Iq_pZYVimWA0kPDb_i4UK_tqXd8fGcCXmaZwVWVlgo?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of CONCAT_WS() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfgwG_wuFM_l4LlanMhl1uqmM_VMYBD5NXmtnruFq-XNFOuSZyC-B_DhyocYlr6EgYyrOM_lxqFRzLFsrR45SgnrAKb_PVjafkEebsm5tc9BYDnICxwprWRGXqzGvc_xIIGk3bF?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Joins numbers with a hyphen.\"\/><\/figure>\n\n\n\n<h2 id=\"find_in_set-search-for-a-value-in-a-list\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FIND_IN_SET_%E2%80%93_Search_for_a_Value_in_a_List\"><\/span><strong>FIND_IN_SET() \u2013 Search for a Value in a List<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This function checks if a value exists in a comma-separated list and returns its position.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe6TfHLRUU6H1m50MoUGy_Lyje1RVResFSbL_6DLvERaj45uw4GMrJvZMMJ5J2NFRtwKGZfFPsnuqrJbPV2v_a8QA-7I_XWceNXwlZW8mwUxL7cc5cy0AWl6ZWZzK6AlBYw71Pl?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of FIND_IN_SET() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeRxhk_AHRZf80QcRGVRZfNCWni87cvVDP1xfHULf0x_0NEcMd9cZkBDWgvaU8FlVLb0l27m8Eir7rjdSfvdxUCeTqQG__HpQejxpLwc6Im7KAwRucGXE0s3HVGA-HDA1ElzYgI?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Finds &quot;Banana&quot; in a list.\"\/><\/figure>\n\n\n\n<h2 id=\"format-format-numbers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"FORMAT_%E2%80%93_Format_Numbers\"><\/span><strong>FORMAT() \u2013 Format Numbers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The FORMAT() function helps you display numbers in a readable way.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc_PfcdC3MMqhbb1jCm_NNUodzseKEmu1WmRuK-v4UQ2W0MrZq2HY-pOM1q2AIQLZqk5hFIANSYpx2jFRkEY4zSNWJValfAA5feFZzoLEh10SbekO4SBNYD0D_ZItbI9rDavN968g?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of FORMAT() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfbaRc7wa9LFkJlUj-pX1IsStop4oL9-McaVMPu3OZLd1TxM-b4UcgEV_AOHDbwUXOxfvhj0uFEDg5yc7MSBxb1ovTC2hygCkJCYjDR6YSXQ-GqbJWrC4mmIvm-tKHuGLvIoI734w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Formats large number.\"\/><\/figure>\n\n\n\n<h2 id=\"lpad-add-padding-to-the-left\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"LPAD_%E2%80%93_Add_Padding_to_the_Left\"><\/span><strong>LPAD() \u2013 Add Padding to the Left<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The LPAD() function pads a string with a specific character to reach a certain length.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfoA3NyaOo35JrGw_T32686clNGYKdin6dOtVFQYaD-JJGsHdHwpYbkBWuyawfQwi83kRDAl4mYIO7263_7LCeRmaMnMUEDOhgxzlvDGR-Fiw_I-tX7alOS28paBf9RRnf4DM1w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of LPAD() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdYoYBQMMYCVpHPG2BP-bs2srLOqHx9Fbag__UCvtcd4W8iWn3bx1xukP3aZ-Y_zb_eGlaeduap1z64YlEakxEfcgw2V6x6a1B4dmWtvbKzo4JMFdsiwPR-gpzHvw_4oGhI3C3A?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Pads &quot;42&quot; with zeros.\"\/><\/figure>\n\n\n\n<h2 id=\"repeat-repeat-a-string-multiple-times\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"REPEAT_%E2%80%93_Repeat_a_String_Multiple_Times\"><\/span><strong>REPEAT() \u2013 Repeat a String Multiple Times<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>REPEAT() repeats a given string a specified number of times.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeOZoNWN1lG_TnAqiJhOMgvHgFPpeszRXtg2LxwkVNVXsik3T-oGsZiefvKikia2PaStiH_sRx1JolLza4YEHKhq-_p1R574YamrA5_UvMM7C2vdcQksqisUPzJGQiN-WvxDh-g?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of REPEAT() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdftR4XE9Pbhv--AnF1lRn1g9dBu3I2R706tB_D3XIQIGGVOQqJcz4dfXpXLPwz-E9Va_Q07HZvkUeqAUm3NNv1QqRSYHQD3pvQxq1ekypuq8o0SYHq0DcGFG86iyCyBIa4T0MrKw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Repeats &quot;*&quot; five times.\"\/><\/figure>\n\n\n\n<h2 id=\"strcmp-compare-two-strings\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"STRCMP_%E2%80%93_Compare_Two_Strings\"><\/span><strong>STRCMP() \u2013 Compare Two Strings<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>STRCMP() compares two strings and returns 0 if they are equal, 1 if the first is greater, and -1 if the second is greater.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeAVKszQJo6Fbjwt__ffucJ1ISIUGxsdtAnzh92J0_SR-F50hyW9O6mNYPhfDKTyu8h3J67ectA2iHtFVndEga6QXu7gfFt8N3Kp_v7MBOvlXWHmim1BlujOEPi2Yb971ESxARc7w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of REPEAT() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfGx3znEAu1L8BpTeQA7f07lBnyigdDsR0nMmRKLwxOZa8gHed2nK_MwnGsUgUGgff7XTI9AjHciRw_GRtpWJmloEK-4X7aba2aXcKENM98Rxo7Rj4XONVWFAIrZaWhJWhgYRl_Nw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Compares &quot;Apple&quot; and &quot;Banana&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"upper-and-lower-convert-case\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"UPPER_and_LOWER_%E2%80%93_Convert_Case\"><\/span><strong>UPPER() and LOWER() \u2013 Convert Case<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>UPPER() converts text to uppercase.<br><\/li>\n\n\n\n<li>LOWER() converts text to lowercase.<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcEYNM6nPo1Th1y6eyJFKo-Ihaj9Vck8bWryzJA1XScK5jzS5lawVhx7ZKKwyqKrqbpK2qS31BwItV0SFnnAFZDbtDKMnT2GjALGxp1q9lDfU-8zs8F0VR2-6XK8UOrzRWBaopG?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of UPPER() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdMeLC5kmwAfqZ0d93lifXUpKl5PRI9Ugmiks9ewIZWkWghvpo8CFZ3WLHJnkKgr8CXv31NWIG5aX5914cE8oMXM3zfPS__STXSbfO41zEiGdZsSYC0EK3ne3FfmBqnqaTCHQbR8w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Converts text to uppercase.\"\/><\/figure>\n\n\n\n<h2 id=\"rtrim-remove-trailing-spaces\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"RTRIM_%E2%80%93_Remove_Trailing_Spaces\"><\/span><strong>RTRIM() \u2013 Remove Trailing Spaces<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>RTRIM() removes spaces only from the right side of a string.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcrZuA-dn3lJn71jK7HQQkRY8Y9O3hIo02W0DWwd8W0sK8eS_U5N6R22-eDLSv9WBZPYzW-K8jByXz0XOJF1cyoQHRWZT4QSw-JKA0GVxuZYJM8tjMPbwUx3T49HHkBmww_C9lM?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of RTRIM() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeAXQkO0fT_TkWy-eJRq4JRdNT10zgcyreO9OrMCYE2zeVf92z5bS9xa_mPuXbrnEXho62B0w-fuJluK5rDKTas5qMxLx0RY9jR0M53WNXOcm9MbOnZLjq_rEBHFg3JR9h-4XO7lg?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Removes trailing spaces from &quot;SQL Basics&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"space-generate-a-string-of-spaces\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SPACE_%E2%80%93_Generate_a_String_of_Spaces\"><\/span><strong>SPACE() \u2013 Generate a String of Spaces<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SPACE() creates a string with a specified number of spaces.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeyIHAMBnLKp0vxhCqAtKhF_3robBLNvcoa47N7ftk09vgoDHTkvZ2IzfBziBBqXUlFLIubB1ZoZVu1PA7KW8miIkZEbzfYHqFByKoH85MjliKw_itLykgdrncK8vPq6fVM9rhFFw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of SPACE() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeUSgiA1ZqidWvGVMcVw08DUXhNyHmkMe6EYSYlr-N-bl94ZZqd2u7Zq6FoZVoeF29aZEdpKbsPBn6kv-aQLXh2TdTje_sV8wyl_D4sbi9oJ-I0mU7WzGQ_9apQLuSUkI3lES79hA?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Inserts five spaces between &quot;Hello&quot; and &quot;World&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"rpad-add-padding-to-the-right\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"RPAD_%E2%80%93_Add_Padding_to_the_Right\"><\/span><strong>RPAD() \u2013 Add Padding to the Right<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>RPAD() adds characters to the right of a string until it reaches a specified length.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXelYE3TbbYAAu6u5gqAGeKhFLqQ7RpBHYk1I5ThMtv__WoVb1bUtm_4qKPVupXJ5DXzYQqiC-ygKicnOkp5o9Iffbz7Wzag7D_d6KOSyDkAwQqGSPk7iak-16rZsSVWEVCJSygYBw?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of RPAD() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdbOZUacefoM3_1PZ8l1avzluI59IdBD-zPHAu9X701vgQJPCkVmTeRbsfKsT_Lv6TgFVBi0k8YFi_3c4WgqpmmF1wSLUS4x8sCd8-0li5h3A2PYJ4dKh1oA96siTXfcKMKpZZw9w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Pads &quot;SQL&quot; with asterisks.\"\/><\/figure>\n\n\n\n<h2 id=\"mid-extract-a-portion-of-a-string\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MID_%E2%80%93_Extract_a_Portion_of_a_String\"><\/span><strong>MID() \u2013 Extract a Portion of a String<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>MID() extracts a substring from a given position and length, similar to SUBSTRING().<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeVH0evJA6ZByLkqZBWpTM8nUaMpy889Clr7ty71jQ_knVrRwDOzZWyREBpLyH-CWuQlB4oY_6EusOF-ICSOZz9aJzb8H9n2I9yvXyJIUHZek_7lDNAroxbmB2oeXQvRZk4YOBhxQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of MID() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe_YNLQ8WCc_96zNommVOr3bTvv-IuEqXvvxLtQL0xtVuLuQRpDTTG1poj2YBO7Fh_U-izYGI9AEsigEykX8DjVnkGj6wxB8CnTw8rggK3SiD9DFdkfb7knreu3BawfncR6sblhVQ?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Extracts &quot;Systems&quot; from &quot;Database Systems&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"position-find-the-position-of-a-substring\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"POSITION_%E2%80%93_Find_the_Position_of_a_Substring\"><\/span><strong>POSITION() \u2013 Find the Position of a Substring<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>POSITION() returns the location of a substring within another string, similar to INSTR().<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXez6_dyndtya2pPwYNmeltQ2ty21MC9E-IepoqtfJ47RziR5upFNWIsa3ZFpBU6FaV9NtNT-uO8mojvyxdOWDdzb7cg0jVIoKNcT6bKaKn8tIOd-RMOLhGR607r4F1y7R5w82Fb2A?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\" Example of POSITION() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcS33LG9-vIBDIeTH-RXbePLA0jdrd5tqzoBEESr883kTUM6sRd6lpbLzCqWJtezmhkv2LfkmeZV7qLA2LyoWzT4fVtgWY81fFGzLkQH8sIdTg5AC9is_fX5yrRFw_JUur0y21u?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Finds &quot;Science&quot; in &quot;Data Science&quot;.\"\/><\/figure>\n\n\n\n<h2 id=\"locate-find-the-first-occurrence-of-a-substring\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"LOCATE_%E2%80%93_Find_the_First_Occurrence_of_a_Substring\"><\/span><strong>LOCATE() \u2013 Find the First Occurrence of a Substring<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>LOCATE() returns the position of a substring in a string, starting from a given index.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfYQQm6g9Vpu7wG2KlMy_DNW44a0XPuJVZNaHyDJQJPFX45ZYb1pWWeAE0MQqrG-9G5WTiH8zTPZ8ELdKGU-ywO2YpYFU3dHua7sbsTdc54AOlve9NNoU4c0XdLuQc3IH2OWx0e6w?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Example of LOCATE() function.\"\/><\/figure>\n\n\n\n<p><strong>Output:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfOYE2bXf0cnt34tCGXtVdXvH5l2mZjWHcKSpRS7dTuNUmBSSBFsE6iXafRQV_AgBtMkuGcJOps_JHU1yWYs8orTB83iv8e5rgwjleffSf5ccgYBrtI6Iu-IBGmUE7vSNGNxKK6-A?key=cLSFEzrSh4g-78A_xqc-7SDn\" alt=\"Finds &quot;a&quot; in &quot;Database&quot; starting from position 2.\"\/><\/figure>\n\n\n\n<h2 id=\"in-closing\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"In_Closing\"><\/span><strong>In Closing<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Mastering SQL string functions is essential for handling text data efficiently. These functions help clean, modify, and extract information, making <a href=\"https:\/\/pickl.ai\/blog\/structure-of-database-management-system\/\">database management<\/a> seamless. Whether you\u2019re concatenating strings, replacing text, or formatting numbers, these functions empower you to manipulate data like a pro.&nbsp;<\/p>\n\n\n\n<p>If you want to enhance your SQL skills and explore <a href=\"https:\/\/pickl.ai\/blog\/what-is-data-science-comprehensive-guide\/\">data science<\/a>, check out <a href=\"https:\/\/www.pickl.ai\/\">Pickl.AI\u2019s data science courses<\/a>. With structured learning and hands-on projects, you\u2019ll gain the expertise needed for a successful career in data analytics. Start your journey today and build a strong SQL and data science foundation!<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-are-sql-string-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_are_SQL_String_Functions\"><\/span><strong>What are SQL String Functions?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL string functions manipulate text in databases. They help combine, extract, format, and clean text data efficiently. Functions like CONCAT(), REPLACE(), and SUBSTRING() make text processing easier. These are essential for managing structured data in SQL queries and improving database performance.<\/p>\n\n\n\n<h3 id=\"how-do-sql-string-functions-improve-data-manipulation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_SQL_String_Functions_improve_data_manipulation\"><\/span><strong>How do SQL String Functions improve data manipulation?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL string functions streamline text handling by allowing users to modify, extract, and search for text in tables. Functions like TRIM() remove spaces, REPLACE() substitutes words, and LENGTH() calculates size, making text analysis more efficient in SQL-based applications.<\/p>\n\n\n\n<h3 id=\"why-should-i-learn-sql-string-functions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_should_I_learn_SQL_string_functions\"><\/span><strong>Why should I learn SQL string functions?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>SQL string functions enhance data querying and transformation skills, making them vital for database professionals. Mastering these functions helps with text analytics, reporting, and automation. Learning them through courses like Pickl.AI\u2019s data science programs can improve job prospects in data analytics and engineering.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"Master SQL string functions like CONCAT(), REPLACE(), and TRIM() to handle text efficiently in databases.\n","protected":false},"author":19,"featured_media":20981,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[613],"tags":[3884],"ppma_author":[2186,2604],"class_list":{"0":"post-20937","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql","8":"tag-sql-string-functions"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL String Functions You Should Know<\/title>\n<meta name=\"description\" content=\"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!\" \/>\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.pickl.ai\/blog\/sql-string-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Essential SQL String Functions You Should Know\" \/>\n<meta property=\"og:description\" content=\"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-01T05:52:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-01T06:04:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Versha Rawat, Abhinav Anand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Versha Rawat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/\"},\"author\":{\"name\":\"Versha Rawat\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/0310c70c058fe2f3308f9210dc2af44c\"},\"headline\":\"Essential SQL String Functions You Should Know\",\"datePublished\":\"2025-04-01T05:52:38+00:00\",\"dateModified\":\"2025-04-01T06:04:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/\"},\"wordCount\":965,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image39.png\",\"keywords\":[\"SQL String Functions\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/\",\"name\":\"SQL String Functions You Should Know\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image39.png\",\"datePublished\":\"2025-04-01T05:52:38+00:00\",\"dateModified\":\"2025-04-01T06:04:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/0310c70c058fe2f3308f9210dc2af44c\"},\"description\":\"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image39.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image39.png\",\"width\":800,\"height\":500,\"caption\":\"sql string functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/sql-string-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Essential SQL String Functions You Should Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/0310c70c058fe2f3308f9210dc2af44c\",\"name\":\"Versha Rawat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/avatar_user_19_1703676847-96x96.jpegc89aa37d48a23416a20dee319ca50fbb\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/avatar_user_19_1703676847-96x96.jpeg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/avatar_user_19_1703676847-96x96.jpeg\",\"caption\":\"Versha Rawat\"},\"description\":\"I'm Versha Rawat, and I work as a Content Writer. I enjoy watching anime, movies, reading, and painting in my free time. I'm a curious person who loves learning new things.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/versha-rawat\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL String Functions You Should Know","description":"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!","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.pickl.ai\/blog\/sql-string-functions\/","og_locale":"en_US","og_type":"article","og_title":"Essential SQL String Functions You Should Know","og_description":"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!","og_url":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/","og_site_name":"Pickl.AI","article_published_time":"2025-04-01T05:52:38+00:00","article_modified_time":"2025-04-01T06:04:08+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","type":"image\/png"}],"author":"Versha Rawat, Abhinav Anand","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Versha Rawat","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/"},"author":{"name":"Versha Rawat","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/0310c70c058fe2f3308f9210dc2af44c"},"headline":"Essential SQL String Functions You Should Know","datePublished":"2025-04-01T05:52:38+00:00","dateModified":"2025-04-01T06:04:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/"},"wordCount":965,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","keywords":["SQL String Functions"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/","url":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/","name":"SQL String Functions You Should Know","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","datePublished":"2025-04-01T05:52:38+00:00","dateModified":"2025-04-01T06:04:08+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/0310c70c058fe2f3308f9210dc2af44c"},"description":"Learn SQL string functions like CONCAT(), SUBSTRING(), and REPLACE() to manipulate text efficiently. Master SQL for better data handling!","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/sql-string-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","width":800,"height":500,"caption":"sql string functions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/sql-string-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/www.pickl.ai\/blog\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"Essential SQL String Functions You Should Know"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/0310c70c058fe2f3308f9210dc2af44c","name":"Versha Rawat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/avatar_user_19_1703676847-96x96.jpegc89aa37d48a23416a20dee319ca50fbb","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/avatar_user_19_1703676847-96x96.jpeg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/avatar_user_19_1703676847-96x96.jpeg","caption":"Versha Rawat"},"description":"I'm Versha Rawat, and I work as a Content Writer. I enjoy watching anime, movies, reading, and painting in my free time. I'm a curious person who loves learning new things.","url":"https:\/\/www.pickl.ai\/blog\/author\/versha-rawat\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2025\/04\/image39.png","authors":[{"term_id":2186,"user_id":19,"is_guest":0,"slug":"versha-rawat","display_name":"Versha Rawat","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/avatar_user_19_1703676847-96x96.jpeg","first_name":"Versha","user_url":"","last_name":"Rawat","description":"I'm Versha Rawat, and I work as a Content Writer. I enjoy watching anime, movies, reading, and painting in my free time. I'm a curious person who loves learning new things."},{"term_id":2604,"user_id":44,"is_guest":0,"slug":"abhinavanand","display_name":"Abhinav Anand","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_44_1721991827-96x96.jpeg","first_name":"Abhinav","user_url":"","last_name":"Anand","description":"Abhinav Anand expertise lies in Data Analysis and SQL, Python and Data Science. Abhinav Anand graduated from IIT (BHU) Varanansi in Electrical Engineering  and did his masters from IIT (BHU) Varanasi. Abhinav has hobbies like Photography,Travelling and narrating stories."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=20937"}],"version-history":[{"count":2,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20937\/revisions"}],"predecessor-version":[{"id":20983,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/20937\/revisions\/20983"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/20981"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=20937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=20937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=20937"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=20937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}