View Single Post
 
Old September 15th, 2003, 03:59 PM
azizmasih azizmasih is offline
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi jepley,

How about the following :-

c5489@PLAY817.WORLD> select * from t ;

X
-------------------------
45
13
meter
32

c5489@PLAY817.WORLD> select sum(translate(x, '0123456789abcdefghijklmnopqrstuvwxyz','0123456789 '))
"sum (services)" from t ;

sum (services)
--------------
            90

c5489@PLAY817.WORLD>


Just put in other characters besides a to z to make the query more robust.

Cheers,
Prat