position

Database
Enthusiast

position

I am having a column in which contains data in this manner:
(123)....(abc).....(567)......... ---this is for one row

I want to display the data in the first enclosed brackets, and the second and the third ....independently.

I tried using position and substring.....but its becoming complex

Is there any easy way to extract those fields.
4 REPLIES
Enthusiast

Re: position

Hi,

If you have fixed length data value, then substring option is the best way to extract the individual data.

Regards,
Balamurugan
Enthusiast

Re: position

it is not fixed length
Enthusiast

Re: position

If it is not a fixed length then try using stored procedure to extract the data..
Enthusiast

Re: position

i want in SQL itself