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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-27 : 23:45:39
|
| geo writes "excuse me. can you tell me how to seperate data from one field, such as I want to seperate "12345/6789" to "12345" and "6789" from one field, but the length of data and "/" position are not fixed. if I just want use the data before "/" to group, how can I use "SELECT...." SQL STATEMENT to solve this problem? thanks!!" |
|
|
|
|
|
seperate data from one field