Formatting Text

• getDate() - returns today’s date

  SELECT getDate()
  

• char_length(data) - returns the length

  SELECT char_length(‘John’)
  

• upper(data) - returns the uppercase

• lower(data) - returns the lowercase

• concatonation

  • SELECT (name +` `+address+`,`+state)

Previous slide

Back to first slide

View graphic version