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 |
|
jaisonlucas
Starting Member
3 Posts |
 Posted - 2009-09-08 : 13:48:59
|
| Hi,i am new to SQL. I have a MSDE database in which an application saves telephone call data. In one particular feild, it saves the data of callnumber call duration in secs seperated by a space.Eg:<callednumber> <secs> 004412121212222 24 where 004412121212222 is callednumber and 24 is the secs called.I wish to filter records where the duration is less than 40 secs and delete these records as they are often the unanswered calls.Kindly helpThanxJaison |
|
|
jaisonlucas
Starting Member
3 Posts |
Posted - 2009-09-08 : 14:17:05
|
| Substring-After function should let me find the string after the space which will give the secs. But the substring-After function does not work in MSDE. If anyone can help me make it work.Thanks |
 |
|
|
|
|
|
Filtering record