parse a string in a SQL select statement

Question

My SQL is very rusty. I would like write a query to take field1

Field1
----------  
Soap       -AC  
Coffee     -AD

and update it to

Field1
----------  
AC_Soap  
AD_Coffee

There will always be the dash between the 2 parts.

David M · Accepted Answer · 2009-07-16 07:08:23Z

1

If you're in SQL Server, you'd do it like this:

UPDATE  table
SET     Field1 = SUBSTRING(Field1, CHARINDEX('-', Field1) + 1, LEN(Field1)) +
            '_' + RTRIM(LEFT(Field1, CHARINDEX('-', Field1) - 1))

answered Jul 16, 2009 at 7:08

David M

73.2k13 gold badges164 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

parse a string in a SQL select statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related