if i have a text as follow :

my phone number is 0123456789

i need to check the text and not allow to have more than 7 digit number occur in the text and then change the 0123456789 to xxxxxxxxx.

Finally the text will become :

my phone number is xxxxxxxxxx

I'm using asp and sql server.....

Hello,

You can do this:

<%

Dim howlong,phone

phone="12312312"

howlong=Len(phone)

IF howlong>7 THEN
Response.Write "Your number is to long"
ELSE
phone="xxxxxxxxxx"
END IF

%>

If you need to remove the number form the text you can use Right(string,length) to cut the number out.

will that help?

Dim strString
Dim i


strString = "my phone number is 0123456789"

for i = 1 to len(strString)
if isNumeric(mid(strString, i 1)) then
strString = replace(strString, mid(strString, i 1), "x")
end if
next


---------------------------------------------------------

out put should be: my phone number is xxxxxxxxxx