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

0 vote146 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote151 views1 answer
How to declare variable date in mysql
SQL
0 vote155 views2 answers
Postgres show current role
SQL
0 vote159 views1 answer
Convert excel into sqllite db using python
SQL
0 vote151 views1 answer
Sql show all users
SQL
1 vote198 views1 answer
Oracle extract minute from date
SQL
0 vote168 views1 answer
Plpgsql if statement
SQL
0 vote152 views1 answer
Top frequency in sql server
SQL
0 vote175 views1 answer
Load data infile mariadb slow
SQL
0 vote173 views3 answers
Mysql regex replace
SQL