stripping data out of a memo field in crystal report/sql

[jenreb1]

in my table, I have a memo field called "child_instructions". In the field's data there is the word SUTURE - I want to strip all the data from BEFORE the word SUTURE off and display the rest.

I tried using the Ltrim function but it doesn't work on the data type memo field .... anyone have an idea on how I can get this data to display ?

TIA.
Jenn

 

[PHV]

Why not posting in a crystal report forum ?

 

[jenreb1]

sorry, I a newbie - I didn't know there was a crystal reports forum.. I will look for it and post it there. thanks