thanks..

Now i got you, please try bellow

static void Main(string[] args)
{
String s = "the bestiality displayed by the main character, Ali, suggests that there is a causality at stake here";
string pattern = @"\bali\b";
string replace = "/";
var s1 = Regex.Replace(s, pattern, replace, RegexOptions.IgnoreCase);
string[] parts = s1.Split('/');
for (int i = 0; i < parts.Length; i++)
Console.WriteLine(parts[i]+ i.ToString());
Console.ReadLine();

    }

http://stackoverflow.com/questions/6025560/how-to-ignore-case-in-string-replace

i tried with your string 'My Name Is Ali' also and it return 'My Name Is'

static void Main(string[] args) { String s = "aaa ali jskdfhskjdfhk ali sjkhfkjsfhkjsdh ali"; var regex = new Regex("ali", RegexOptions.IgnoreCase); var s1 = regex.Replace(s, "/"); string[] parts = s1.Split('/'); for (int i = 0; i < parts.Length; i++) Console.WriteLine(parts[i]); Console.ReadLine(); }

try this string s="test1 ali test2 ali"; string[] parts = s.Replace("ali", "/").Split('/');

try the following <%@ Page Language="C#" .......... EnableEventValidation="false"%> in code don't forget to add

Public Overrides Sub VerifyRenderingInServerForm(control As Control)
' Confirms that an HtmlForm control is rendered for the specified ASP.NET '
' server control at run time. '
End Sub

try now I forgot to add table name

SELECT ROOM.HotelNo, ROOM.RoomNo from ROOM
LEFT JOIN RESERVATION ON (ROOM.HotelNo = RESERVATION.HotelNo) AND (ROOM.RoomNo = RESERVATION.RoomNo)
WHERE (((RESERVATION.HotelNo) Is Null) AND ((RESERVATION.RoomNo) Is Null))
ORDER BY ROOM.HotelNo

create table #tmp (ColA varchar(2),ColB varchar(100)) insert into #tmp select '1', '12.324.145' union all select '2', '425.152.643' union all select '3', '12' select a.ColA,t.c.value('.','varchar(100)') as col2 from (select cola,cast(''+replace(colB,'.','')+'' as xml) as c2 from #tmp) a cross apply c2.nodes('/t') t(c)

add one column of to identify the table name like Select 'T1' as tbl, T1CL1 as col1,T1CL2 as col2 from T1 where T1CL3 = 'Something' union all Select 'T2', T2CL1,T2CL3 from T2 where T1CL2 = 'prm1' union all Select 'T3', T3CL3,T3CL4 from T3 where T3CL2 = 'prm2' union all Select 'T4',T4CL1,T4CL3 from T4 where T4CL2 = 'prm3' union all Select 'T5',T5CL1,T5CL3 from T5 where T1CL2 = 'prm4'

SELECT HotelNo, RoomNo from ROOM
LEFT JOIN RESERVATION ON (ROOM.HotelNo = RESERVATION.HotelNo) AND (ROOM.RoomNo = RESERVATION.RoomNo)
WHERE (((RESERVATION.HotelNo) Is Null) AND ((RESERVATION.RoomNo) Is Null))
ORDER BY ROOM.HotelNo