Skip to main content

Remove the last character in a string in -SQL Server

Remove last character  or no of character remove in SQL server. Its so easy in sqlserver built in function with SUBSTRING , sometimes its little bit tricky for developer when he/she forget about SUBSTRING method.


SUBSTRING ( expression ,start , length )  



Original String is 'My Name Is Maksud,'



SELECT SUBSTRING('My Name Is Maksud,', 1, LEN('My Name Is Maksud,') - 1) AS ResultString





















You can do this in C#, here you go Remove the last character in a string in -C#












Labels:





























Comments











Post a Comment































Popular posts from this blog





















What are the difference between DDL, DML , DCL and TCL commands?




























       Database Command Types     DDL   Data Definition Language  (DDL) statements are used to define the database structure or schema.    -           CREATE - to create objects in the database   -           ALTER - alters the structure of the database   -           DROP - delete objects from the database   -           TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed   -           COMMENT - add comments to the data dictionary   -           RENAME - rename an object     DML   Data Manipulation Language  (DML) statements  are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to d...




















2 comments









Read more




























Ubuntu/Unix Console Command -Cheat Sheet




























M ost popular Linux/Unix command those are required to know during working on Linux/Unix environment. Primarily, when I started the work on ubuntu, I faced a common problem that was not familiar to know about the basic ubuntu command. After that, I aggregate basic commands and work very well. Besides that, most of the time forgot the command and this helps me to cut-down googling time.         Privileges              SL          Command          Use / Description              1          sudo command          Run command as root              2          sudo -s          Open a root shell              3          sudo -s -u user          Open a shell as user              4          sudo -k          Forget sudo passwords              5          gksudo command          Visual sudo dialog (GNOME)              6          kdesudo command          visual sudo dialog (KDE)              7          sudo visudo          edit /etc/sudoers              8          gksudo nautilus          root file man...




















Post a Comment









Read more




























Display Image Immediately from fileUpload Control




























  Client Side Programming is more efficient for user to very first interection Like Jquery . Now i provide some jquery script to display Image from FileUpload Control directly..   For this purpose we use reference . <script src="../../../JS/JQueryAutocomplete/jquery-1.7.2.js" type="text/javascript"></script>. You just download from jquery.com.   Now code below...   <script language="javascript" type="text/javascript">   /* Write FileUpload Change event .. */    $('#FileUpload1').bind('change', function() {                                  displayImage(this);                      });  //-------------------------//    function displayImage(input)              {         ...




















1 comment









Read more