How to split a variable into two using SQL?

Question

I have a variable, @RegionPeril retrieved from a cursor and I want to know if I can split this variable into two.

@RegionPeril can be the following (but not limited to):

WS EU
WS CA
EQ Worldwide
FL ROW

I want two variables: @Peril and @Region where @Peril = WS or @Peril = EQ (there can be more but it's the first two strings of the @RegionPeril variable) and @Region = EU or @Region = Worldwide (and so on...this is the 3rd string till the end of the @RegionPeril variable)

Is there any way to split this up??

Any help will be appreciated!

Good, then my answer below should work :)

Jim
– Jim

2012-09-19 19:28:08 +00:00
Commented Sep 19, 2012 at 19:28 — Jim
– Jim, Commented Sep 19, 2012 at 19:28

Jim · Accepted Answer · 2012-09-19 19:27:13Z

2

Something like this should work (Assuming the first item in @RegionPeril is always 2 chars):

SELECT 
    @Region = LEFT(@RegionPeril, 2), 
    @Peril = RIGHT(@RegionPeril,LEN(RegionPeril)-3)

Or if Region can be of various lengths:

SELECT
    @Region = LEFT(@RegionPeril, CHARINDEX(' ', @RegionPeril)),
    @Peril = Right(@RegionPeril, LEN(@RegionPeril) - CHARINDEX(' ', @RegionPeril))

answered Sep 19, 2012 at 19:27

Jim

3,55724 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

How to split a variable into two using SQL?

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