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 - 2005-09-30 : 07:26:22
|
| Viggy writes "from <sip:0014084704700@63.123.193.53>;tag=418342B8-1E1Fi just want 0014084704700. please help me out with this." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-30 : 07:28:12
|
| DECLARE @a varchar(100)SET @a='<sip:0014084704700@63.123.193.53>;tag=418342B8-1E1Fi'SELECT SubString(@a, CharIndex(':', @a)+1, CharIndex('@', @a) - CharIndex(':', @a)-1) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-30 : 07:29:28
|
| Is this?Declare @s varchar(50)set @s='0014084704700@63.123.193.53>;tag=418342B8-1E1Fi'Select left(@s,charindex('@',@s)-1)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
seperating a string into components