>>Another thing, I have written a SP that converts from string to

>>but as far as I know it is not possible to do something like this:
>>
>>sel ...
>>from ...
>>where SP_STRINGTONUM(col1) > 123
>>
>>But the same thing is possible with UDFs? Like:
>>
>>sel ...
>>from ...
>>where UDF_STRINGTONUM(col1) > 123
>>
>>If so are there any UDFs freely available? I couldn't find any in
>>fbudf.dll or ib_udf.dll.

>Goodness, you don't need any of that.

>CAST ('123' AS SMALLINT) is all you need.

>/heLen