Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add records from one table to another
Message
From
06/07/2017 14:25:26
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Add records from one table to another
Miscellaneous
Thread ID:
01652499
Message ID:
01652509
Views:
38
>>Yes, there are CHARINDEX and SUBSTRING functions in SQL Server. In SQL Server 2016 (I think) they also finally introduced the split function.
>
>Thank you.

You're welcome. Play with the select statements first until you get it parsed correctly.

This blog post may help

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/parsing-fullname-field-to-individual/
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform