Separate a column into 2 columns

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

bang725 Mr or Mrs. 500 Points: 577 More actions · Answer 1

refer this

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

Hi

This is a basic example you may need to change it if you don't want leading spaces etc.

DECLARE @string VARCHAR(100)

SET @string = '123-458-856 -AD45 EXP 01/01/01'

SELECT

@string as [My String],

LEFT(@string,CHARINDEX('EXP',@string,0)-1) as [Column 1],

RIGHT(@string,LEN(@string)+2 - CHARINDEX('EXP',@string,0)) as [Column 2]

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Johan Bijnens SSC Guru Points: 135376 More actions · Answer 3

seems to me like your data after exp is a date, so make it a datetime column !

pro:

- only date(time) values accepted

- the whole bunch of datetime related functions

con:

- no invalid dates allowed :w00t:

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this