mardi 12 mai 2015

Regular expressions in TSQL

In cell e_vis_name i have organization structure where divisions divided with \ symbol, e.g.

  • Moscow\Direction
  • Yaroslavl\Sales
  • Omsk\Commercial center\Sales

I need to cut everything after first \ symbol to get the following result: - Moscow - Yaroslavl - Omsk

How can I do it?

Aucun commentaire:

Enregistrer un commentaire