@bteraberry

ya

@david-2

When i'm trying to perform a join operation on that table with another table with 400 records based on some condition its taking more that 20 mins...

@string=\\abc\tri\eds\rf

i used substring(@string,charindex('\', @string),charindex('\',@string,charindex('\',@string,charindex('\',@string,charindex('\',@string,charindex('\',@string)+1)+1)+1)+1)

i tried to learn how to get that but couldnt...

please help me out with that

@cory

thanq for ur response

but what if i had

\\abc\xyz\wzy\123\toi

and i want to get only

\\abc\xyz\wzy

@cory

yes exactly cory

@Lynn

yes lynn

@lenin

previously i worked on fixed lenth part of string

so i used to use substring and charindex with a particular length

but here the string lenght between 1st'\' and...

@ all

thank you guys..

i got it..

but i got one more qstn

i got another row in that

\\xyz.ed.kl.e.a\fgd\\rsq.fd.ij.g.b\fgd\\wes.as.gh.c.b\fgd\\abc.er.tf.h.d\fgd\\eds\fgd

now when i'm trying to print the result for all the rows after eliminationg...

@pablo-2

Thanks for ur help

what if i got different rows in that column like

example:

Colum1

\\xyz.ed.kl.e.a\fgd\\rsq.fd.ij.g.b\fgd\\wes.as.gh.c.b\fgd\\abc.er.tf.h.d\fgd

what if i want to get the rows with the part of the string starting...

@cory

Thankq cory

i got it.

And for now lets forget about column2

i jus want to eliminate that part of string. Can u help me with query whihc will eliminate that part.

I really...

i need a query to eliminate that highlited part of the string so that after elimination it looks like the row in colum2