Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2014-08-14 : 02:41:37
|
| i have a long list of string that look like this:7/5/2014 0:0:0 AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 7/5/2014 19:10:0 7/5/2014 23:30:0how can i add in some indicator in between the data to indicate arrival and departure? is it possible?7/5/2014 0:0:0 DEPARTURE AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 ARRIVAL 7/5/2014 19:10:0 7/5/2014 23:30:0 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-14 : 07:59:49
|
| sure it's possible. Check out BOL for info on CHARINDEX, PATINDEX and SUBSTRING |
 |
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2014-08-14 : 21:58:17
|
| how to add in? any sample? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-15 : 08:27:48
|
| Did you read up on CHARINDEX, PATINDEX and SUBSTRING? If not, start there. If so, what have you tried so far? |
|
|
|
|
|
|
add in between data