How To Get Part Of The Column Value In Sybase Where This Column Situated In A Query Which Is Inside Other Query?

I have a column named Cons in a table named Conses as Order::Resource(PPP32#BB300320LQ00J#AAAR05504) I have second table which depends on first table. i wants to get all data from

Solution 1:

You simply have to do string manipulation.

Use substring, charindex, char_length, right and left functions :)

---

declare@stringvarchar(50)
select@string='Order::Resource(PPP32#BB300320LQ00J#AAAR05504)'declare@startint, @endint, @secondstringvarchar(100)

select@start= charindex('#',@string)
select@secondstring=substring(@string, @start+1, len(@string))

select@end= charindex('#',@secondstring)

selectsubstring(@string,charindex('(', @string)+1, @start-1-charindex('(', @string)),
       substring(@string,@start+1,@end-1), 
       substring(@string, @start+@end+1, len(@string)-(@start+@end+1))