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 |
|
Kabotoro
Starting Member
1 Post |
 Posted - 2009-05-21 : 14:17:57
|
| Does anyone has a split function that I can use to split a string into two columns. Below is my string.@pp = '1~600|2~400|3~900|4~100'I would like to split the string first using the pipe to have one part of the string and then split that part of the string using tilde and insert two columns in the table.egID Amount1 6002 4003 9004. 100Any help will be appreciatedThanksKB |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Split Function