Split Left SQL [ValueToSplit] Field 0 Split SUBSTRING([ValueToSplit],1,CHARINDEX(' ',[ValueToSplit])) Split Right SQL [ValueToSplit] Field 0 Split SUBSTRING([ValueToSplit],CHARINDEX(' ',[ValueToSplit]),50)