Split Column Data into 3 Columns

[Khanson82]

I'm sure this is basic, but I have this data for one field:

03/24 08:10AM CST Call Attempt 4: na at hm

I want col1 to include everything through the time zone.
Col2 should be everything after time zone up to semi-colon.
Col3 will be whatever is left.

The only data that has the same amount of characters always is col 1 data.

Thanks again.

 

[Crowley16]

this isn't some piece of homework is it?

it's really quite simple to do this with the left, substring and charindex functions, google for how to use.

there's also the right and len functions which may be of help.

--------------------
Procrastinate Now!

 

[Khanson82]

Nope, Having to learn SQL on the fly and couldn't find an example that would work for this so far...

I'll look those solutions up. Thanks again.