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
I want to write a sql statement to trim a string ‘Hello’ from the string “Hello World’. Please suggest.
select substring( field, 1, 5 ) from sometable