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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-03-09 : 04:57:12
|
| hello, I have this code that helps me count the number of entries a users who chooses to bulk post sms via my website to cell phone numbers.Basically it counts the number of phone numbers seperated by commasI would also like to add to this code, to check for certain numbers[CODE]select len(colname) -len(replace(colname,',','') + 1 as number_of_items...[/CODE]I would like to add additional funcitonality to it, to be able, to search for how many numbers start with either 1, 234804 or 44And assign the total to a variable. And the remaining total to another variable. Its meant to work for our billing platformHow do i achieve this efficientlythanksAfrika |
|
|
|
|
|
Checking for certain numbers