Hi,

I have column values like ---- com.integrosys.sml.app.facility.vo.OBFacility[5647].Pricing Result

in my table .

i need to write a sql query fetching only the number inside the square braces(5647).

how to use regex for this .i am using oracle 10g

regards
Raj

SELECT REGEXP_SUBSTR(columnname ,'[[:digit:]]+') from table

I was looking for something like that in Microsoft SQL but I could not get MS-SQL to find the CHARINDEX of "[".

Your answer looks good from here since I don't work with Oracle.

Thanks for posting the solution.