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