Saturday, October 20, 2012

Get String from stating to second last index in sql server

Declare summary varchar(50)
@Summary="sanjay,raju,chirag,"

I want to remove , from last index,i do this as bel
ow :


Select @Summary=SUBSTRING(@Summary,0,len(@Summary))
select @Summary

Result :


sanjay,raju,chirag

If you are searching life partner. your searching end with kpmarriage.com. now kpmarriage.com offer free matrimonial website which offer free message, free chat, free view contact information. so register here : kpmarriage.com- Free matrimonial website