How to split a string dynamically

you can use something like below code snippet :

string strName = "Mr.Dileep Kumar Reddy";
if (strName.StartsWith("Mrs.", StringComparison.CurrentCultureIgnoreCase))
{
    strName = strName.Substring("Mrs.".Length).Trim();
}
else if (strName.StartsWith("Mrs", StringComparison.CurrentCultureIgnoreCase))
{
    strName = strName.Substring("Mrs".Length).Trim();
}
else if (strName.StartsWith("Mr.", StringComparison.CurrentCultureIgnoreCase))
{
    strName = strName.Substring("Mr.".Length).Trim();
}
else if (strName.StartsWith("Mr", StringComparison.CurrentCultureIgnoreCase))
{
    strName = strName.Substring("Mr".Length).Trim();
}

In VB.Net

Dim strName As String = "Mr.Dileep Kumar Reddy"
If strName.StartsWith("Mrs.", StringComparison.CurrentCultureIgnoreCase) Then
    strName = strName.Substring("Mrs.".Length).Trim()
ElseIf strName.StartsWith("Mrs", StringComparison.CurrentCultureIgnoreCase) Then
    strName = strName.Substring("Mrs".Length).Trim()
ElseIf strName.StartsWith("Mr.", StringComparison.CurrentCultureIgnoreCase) Then
    strName = strName.Substring("Mr.".Length).Trim()
ElseIf strName.StartsWith("Mr", StringComparison.CurrentCultureIgnoreCase) Then
    strName = strName.Substring("Mr".Length).Trim()
End If

[Edit (Matt T Heffron): You must first check for the strings that are prefixes of other strings. (I.e., "Mrs.", "Mrs", "Mr.", "Mr") or else the "Mr" will get removed from "Mrs Rubeena Naaz" leaving "s Rubeena Naaz" !
Actually, I'd probably use the technique shown in my Solution 4.]

I'd probably use a static array of prefixes and loop through them:

// Always order so values that include others as prefix are checked first.
private static readonly string[] StrippablePrefixes = { "Mrs.", "Mrs", "Mr.", "Mr" };
// This would be at the class level.
// It could include other titles: e.g., Dr., Miss, Ms., ...

// To strip any prefix that might be present:
foreach (string prefix in StrippablePrefixes)
{
  if (strName.StartsWith(prefix, StringComparison.CurrentCultureIgnoreCase))
  {
    strName = strName.Substring(prefix.Length);
  }
}
strName = strName.Trim();	// Do this here so it happens even if no prefix is removed

In VB.NET you can use following command to split a sentence in to words :

dim NAME as string="Mr.Dileep Kumar Reddy"

Use replace command to remove dot from NAME like

NAME = replace(NAME ,"."," ")
Dim w_ords() As String = Split(dr("NAME"))

This way u can separate the prefix i.e. salutation.
Please check array w_ords(0).