While in SQL Server 2005, how do I split a string so I can access item x?
Let’s say I have a string “Peyton Manning”. Is there a way to split the string by adding a space and accessing the item at index 1 so that it reads "Peyton"?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!