Delete Last Digits

[alirezaok]

hello

i have a table with 2 field

name of table : number
name of fields : 1-name (type : text) 2-telnum (type: integer)

content of telnum field are numbers (8 digits)

example:

telnum
25476547
45214568
21458756

i want delete last digit of telnum field and numbers change to 7 digits

example:

telnum
2547654
4521456
2145875

i think if all number\10 (no number/10) then they are done and last digit will be remove (this is a way)

i connected to database

anyone can write a update or repalce script for delete last digits for me?

[mark_and_co]

substr($telnum, 0, 7);

this should do it