Monday, 13 February 2012

how to substring one comma saperated column values

Select            
  @FirstName=Substring(@RecipientName,1,charindex(',',@RecipientName,1)-1),           
  @LastName=Substring(@RecipientName,charindex(',',@RecipientName,1)+1,len(@RecipientName)) 

No comments:

Post a Comment