Select
@FirstName=Substring(@RecipientName,1,charindex(',',@RecipientName,1)-1),
@LastName=Substring(@RecipientName,charindex(',',@RecipientName,1)+1,len(@RecipientName))
@FirstName=Substring(@RecipientName,1,charindex(',',@RecipientName,1)-1),
@LastName=Substring(@RecipientName,charindex(',',@RecipientName,1)+1,len(@RecipientName))
No comments:
Post a Comment