Home Forums SQL Server 2008 SQL Server 2008 - General Extracting from one cell in excel. and from RE: Extracting from one cell in excel. and from
watchgeek
SSC Veteran
Points: 291
More actions
May 20, 2014 at 5:30 pm
#1715189
I did not use Right (..,..).
I put each words into an array. and got the size of the array. if the size of the array is X, I got the last three words by words[x-2],words[x-1],words[x]
each word occupies a space in array. not each character.