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

15 votes227 views5 answers
Show tables in oracle
SQL
8 votes226 views2 answers
Between operator
SQL
0 vote236 views3 answers
Condition in count sql
SQL
5 votes226 views1 answer
Sql select ciunt
SQL
0 vote226 views1 answer
Connect to nginx server mysql remotly
SQL
2 votes228 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote204 views1 answer
Wordpress sql change site url
SQL
0 vote226 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote222 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote242 views2 answers
Oracle chain rules
SQL