> Hi,
>
> Which function should I use to find the position of a substring
> (actually a single character) in another string? If it's an UDF,

please

> specify which library and how I should declare the external

function.

>
> Many thanks,
> Kjell

Hello friend,I guess the following code will do the work.

DECLARE EXTERNAL FUNCTION SUBSTR
CSTRING(80),
SMALLINT,
SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT 'IB_UDF_substr' MODULE_NAME 'ib_udf'

execute the above code,after that u can use the substr UDf.

shaam