Thursday, 9 January 2020

Sql Server – Split Column With Delimited String Into Multiple Columns

Method 1: To Split A Column With Delimited String Into Multiple Columns more...

Method 2: SELECT
                       PARSENAME(REPLACE ('John,Doe', ',', '.'), 2) 'First Name',
                       PARSENAME(REPLACE ('John,Doe', ',', '.'), 1) 'Last Name'

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Google Form using App Script

Create a Google Sheet with the following headers: First Name, Last Name, DoB Create a Google Form with the exact headers as Google Sheet he...