[v1brazy]

Hya all,

Im currently designing a website in Dreamweaver MX, using ASP (Javascript) and MS Access.

What I need to do is retrieve all telephone numbers from the database and display it on the page. But i want it so only the first 5 numbers of the telephone number will show and the rest would be *****.

I have been looking at some SQL statements such as RPAD, LPAD, but it doesnt seem to work with my statements when building my recordset.

Can anyone give me some ideas please..

Thanks you all

[Xtremist]

search for truncate..... It will tell you all you need to know...

You will do something like this...

Create the recordset..... in this case it's called getphoneno.

Get the value from the DB and assign it to phoneno
<% phoneno =(getphoneno.Fields.Item("fphoneno").Value)%>

Now display it but cut it down to 5 numbers
<% = left (phoneno,5) %>

The output for 999-999-9999 would be 999-9. You could add some * so make it appear like: 999-9**-**** if you wanted....

If you wanted to show the last five you would use the work right instead of left and you can also use mid is you want to take some out of the middle.

Hope this helps,

Chris