Ok am fairly new to ASP. managed to display data thats only to left side of a special character "ý". Problem - What if the field does not have special character. Getting the following error message

Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Mid'
/civil.asp, line 412

Following code where error takes place:

<td width="420" nowrap>&nbsp<%
Dim strPtext, strPname, strPchar, intPcount
strPchar = "ý"
strPtext = objRs("p_name")
intPcount = Instr(strPtext, strPchar)
strPname = mid(strPtext, 1, intPcount-1)
Response.Write strPname
%>
</td>

Dire need of help!!!

Mike

__________________
Mike

Before calling mid function, you can check the count of intPcount variable. call mid function only when you find the special char.

Om Prakash

thanks Om Prakash, you were a big help. Was able to make it work with your advice. Again many thanks.

Mike