mercredi 6 avril 2016

Substring of Url's on a column in Sql Server 2012

Since I am new to Sql Server, I am trying to take substring of this url in Item Url Column eg: http://ift.tt/1SAeU8e Party Action

I want the Related Party Action from this url. I have tried charindex and substring,but confused with the positioning. Also I want every url in ItemUrl column to be like this.Please help me with the select query.

Aucun commentaire:

Enregistrer un commentaire