Skip to content
Advertisement

trim left characters in sql server?

I want to write a sql statement to trim a string ‘Hello’ from the string “Hello World’. Please suggest.

Advertisement

Answer

select substring( field, 1, 5 ) from sometable
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement