Dear All,

I am looking for any function that fetches the integer portion from string
in DB2 UDB V 8.1

Eg:

Lets consider a function "fx"

12-Sales à So fx('12-Sales') should return 12.

fx('sales') should return either NULL or 0.



Thanks

Thirumaran





DB2 & UDB email list listserv db2-l LazyDBA home page