Sql delimiter to columns

SELECT 
     REVERSE(PARSENAME(REPLACE(REVERSE(myAddress), ',', '.'), 1)) AS [Street]
   , REVERSE(PARSENAME(REPLACE(REVERSE(myAddress), ',', '.'), 2)) AS [City]
   , REVERSE(PARSENAME(REPLACE(REVERSE(myAddress), ',', '.'), 3)) AS [State]
FROM dbo.custAddress;
GO

Source: mssqltips.com

Similar codes

1 vote124 views1 answer
What is in condition in sql
SQL
7 votes121 views2 answers
Add column table pl sql
SQL
0 vote125 views1 answer
Sqlite referential integrity
SQL
0 vote122 views1 answer
Sql server order by nulls last
SQL
22 votes161 views4 answers
Mysql format date
SQL
0 vote136 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote127 views2 answers
Database owner can't create new tables postgres
SQL
0 vote136 views1 answer
Add two days to current date in sql when creating tables
SQL
1 vote122 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote122 views3 answers
How to get date in sql
SQL