Hi,

I have a query which dispalys the o/p of script name,path,server info etc,..But i want to extract only script name from this. The problem here is if we write any substr stmt it will mnot give result properly ,becos he parameters that o/p is displaying will vary from query to query.....


Thanks,
Pavan
db2-UDB dba

Do you have any example of input and the desired output ???

truepavan, without knowing your data or a sample (as sathyaram_s asked for), I can only guess.

You may be able to use the LOCATE function to find the starting position of what you are looking for. Then you can use that as the second position of the SUBSTR function.