trim left characters in sql server

Question

I want to write a sql statement to trim a string  Hello  from the string  Hello World   Please suggest

User · Answer

For  Hello  at the start of the string   SELECT STUFF  Hello World   1  6        This will work for  Hello  anywhere in the string   SELECT REPLACE  Hello World    Hello

User · Answer

use  LEFT    select left  Hello World   5    or use  SUBSTRING    select substring  Hello World   1  5

User · Answer

You can use LEN in combination with SUBSTRING   SELECT SUBSTRING myColumn  7  LEN myColumn   from myTable

User · Answer

To remove the left-most word  you ll need to use either RIGHT or SUBSTRING  Assuming you know how many characters are involved  that would look either of the following   SELECT RIGHT  Hello World   5  SELECT SUBSTRING  Hello World   6  100    If you don t know how many characters that first word has  you ll need to find out using CHARINDEX  then substitute that value back into SUBSTRING   SELECT SUBSTRING  Hello World   CHARINDEX       Hello World     1  100    This finds the position of the first space  then takes the remaining characters to the right

User · Answer

select substring  field  1  5   from sometable

[sql] trim left characters in sql server?

Examples related to sql

Examples related to sql-server