Hi All,
I have a hard time creating a solution on how to get a certain value on a certain column. I am using Firebird 2.0 version.
Field1
VESSEL_ID IS NULL) THEN  NEW.VESSEL_ID = GEN_ID(GEN_VESSEL_ID,1);
COMPANY_ID IS NULL) THEN  NEW.VESSEL_ID = GEN_ID(GEN_VESSEL_ID,1);
On the above example, I want to get the "Vessel_ID" and "Company_ID". I can not make a SUBSTRING because it only uses fixed lengths.
I want the results to be like this: see below..
Field1
VESSEL_ID
SYSTEM_ID
Kindly help me on this. Thanks in advance!
Regards,
Jack


____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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