Partial string replacement

[Raul2005]

I have the follwing:
afsfffdfREMARKSdddddd
returned on my record and I need to detect for REMARK and replace all what I have before with empty spaces so my final result will be

REMARKSdddddd

Thanks

 

[mrdenny]

Look into substring.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[amrita418]

If the literal "remark" could be anywhere in the string then use charindex.

What should be the result set does not contain "remark"? Do you want to return the whole text then?

select substring('afsfffdfREMARKSdddddd', charindex('demark', 'afsfffdfREMARKSdddddd'), len('afsfffdfREMARKSdddddd'))

Regards,
AA

 

[Raul2005]

Thanks amrita
I have a question..This string is returned from database and I have not control of what is going to return. sometimes it could be
udadasdREMARKnnnnn
hhhhhhhhhhhhhhhhhhhhhhhhREMARKffffffffffffffff
As you see it is not an static string and the result should be all what I have after the word REMARKS


I will appreciate any ideas

 

[amrita418]

Plug both your examples in the code that I provided and you will see that only characters from Remark are displayed.

My question to you was, what should be the output if row does not contain remark (example hhhdemarkggg)?

 

[Raul2005]

No problem we are filtering all records that contain remarks, so all recordset will containg remarks some how..

Thanks