SQL Get the First and Last Word from a String or Sentence in SQL - 11.06.18 | 30.08.20 - ErcanOPAK comment on Get the First and Last Word from a String or Sentence in SQL You can use query below: Continue Reading ..
SQL Capitalize words in SQL (Display data first letter uppercase rest lowercase) - 08.06.18 | 22.11.19 - ErcanOPAK comment on Capitalize words in SQL (Display data first letter uppercase rest lowercase) SELECT UPPER(LEFT(colname,1)) + LOWER(RIGHT(colname, LEN(colname) – 1)) FROM tablename Continue Reading ..