Replies |
Hadyallam
Posted on: 7/24/2012 8:07:47 AM
|
Level: Starter | Status: [Member] | Points: 25
|
string StringAfterModification= "";
string num = "0123456789";
foreach (char t in MyString)
{
if (num.Contains(t))
{
StringAfterModification+= t;
}
}
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Hadyallam
Posted on: 7/24/2012 8:08:38 AM
|
Level: Starter | Status: [Member] | Points: 25
|
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Pandians
Posted on: 7/24/2012 8:12:18 AM
|
Level: Silver | Status: [Member] [MVP] | Points: 50
|  Check it out! Select SUBSTRING(ItemDescription,PATINDEX('%[0-9]%',ItemDescription),LEN(ItemDescription)) from <TableName> Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Ranjeet_8
Posted on: 7/24/2012 8:33:18 AM
|
Level: Gold | Status: [Member] | Points: 25
| Try This.
Select SubString(Column_Name, PatIndex('%[0-9]%', Column_Name), 8000) From Table_Name
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Hi
try
SELECT RIGHT(ItemDescription, 4)
Regards
R D Patel
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Vuyiswamb
Posted on: 7/24/2012 9:07:48 AM
|
Level: NotApplicable | Status: [Member] [MVP] [Administrator] | Points: 25
| Questions
Vizio0001
RIM0002
Dell0003
Malata0004
eLocity0005
First find the occurance of a number and do a substring to get the remaining numbers.
Thank you for posting at Dotnetfunda
[Administrator]
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Jasminej
Posted on: 7/25/2012 12:41:49 AM
|
Level: Starter | Status: [Member] | Points: 25
|
Jasminej, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|