[text] c

Viewer

  1. SELECT SUBSTRING(Name, 3) AS name_substring,
  2.        CHARINDEX('e', SUBSTRING(Name, 3)) AS first_e_occurrence,
  3.        CHARINDEX('e', SUBSTRING(Name, CHARINDEX('e', Name)+1)) AS second_e_occurrence
  4. FROM Employees
  5. WHERE CHARINDEX('e', name) > 0;
  6.  

Editor

You can edit this paste and save as new:


File Description
  • c
  • Paste Code
  • 05 Jun-2023
  • 248 Bytes
You can Share it: