Hi Guys,

I am trying to retrieve a Substring from a memo field in a Triger, and I am not very familiar with firebird.

I just need to get everithing on the rigth of the last ";" or in other words copy to a new field everithing after the last ";" from a memo field. Can someone help me please with it?


I would write it something like:

Last_DotComma = 1
Loop while Last_DotComma < Len(MEMO) or Last_DotComma = 0 or Len(MEMO) = 0
Last_DotComma = INSTRING(';',MEMO,1) // ASSUMING the third param is "Starting from"
end

if Last_DotComma > 0 then new_string = SUB(MEMO,Last_DotComma + 1,Len(MEMO))
END

Is there any "book" or PDF with all the valid Firebird SQL Functions??
Regards
Fabian.









[Non-text portions of this message have been removed]