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 vote339 views1 answer
Wherein mysql
SQL
0 vote322 views1 answer
Sql trigger to call stored procedure with parameters
SQL
8 votes341 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote316 views1 answer
How to change the field size of an existing column
SQL
0 vote321 views1 answer
Mysql config slave
SQL
0 vote349 views1 answer
Mysql case when on date
SQL
0 vote351 views1 answer
Oracle grant create job
SQL
0 vote339 views1 answer
Sql alter column name sql server
SQL
0 vote306 views1 answer
Raiserror nowait sql server
SQL
2 votes351 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL