1

I need a ANSI SQL 92 statement to change all characters following the last '/' character to lower case.

On Sybase I would write:

update table 
set col = left(col, len(col)-charindex('/', reverse(col))) ||
          lower(right(col, charindex('/', reverse(col))))

I can find all functions in ANSI SQL 92 but the REVERSE function, that I just use to find the last occurrence of the slash.

Deduplicator
  • 44,692
  • 7
  • 66
  • 118
ph8c4
  • 96
  • 1
  • 7

0 Answers0