Why Interbase has not string functions?

[RSK]

Hi all,
Why Interbase has no string function shuch as substr, left, right, .. that
most other have them. For example I found that I can write more powerful
queries with MSSQL server but I like to do that works with interbase without
using external udf or stord procedures that have them difficulty and side
effects.

Best regards,
RSK.

[Daniel Magin]

hi rsk,

.. but I like to do that works with interbase without

> using external udf or stord procedures

the answer is very simple, with udf you can do what ever you like. and
there is no reason why not to use udf. udf's are so great to enhance
your server with any functions what you like. FreeUdf for example give
you a big collection for string manipulation.

so i suggest work with it, and you will love it.

daniel magin :-)

[RSK]

Hi Daniel, Hi Robert

Thank you for your attentions,
I think that udf reduse the server speed an might have some other side
effects. I read about this in some articles. In one of them, stored
procedures was prefered instead of udf.

Best regards,
RSK.

"RSK" <tecdi...@yahoo.com> wrote in message
news:41ff...@newsgroups.borland.com...

[Aquila Deus]

But if you're a developer, the lack of built-in functions means that
your end-users have to install these UDFs by themselves, and they
probably also need to test the compatibility, no to mention that some
of UDF libraries may not work on all platforms that interbase support.

[M]

> Hi Daniel, Hi Robert
>
> Thank you for your attentions,
> I think that udf reduse the server speed an might have some other side
> effects. I read about this in some articles. In one of them, stored
> procedures was prefered instead of udf.

Stored procedures should be used for data manipulation. UDFs are more
suited to simple mathematical and string functions.

Mike

[Daniel Magin]

hi rsk,for math or string functions udf's are great and high speeded. i
use udf's for example of a big database for car manufactor (one of the
biggest in world) to calculate the finance and leasing conditions from a
database wich has all possible methods to order a car. we use this udf
on the databse wich is connected from the webserver. a delphi 2005
client call the interbase server with sql statements to stored
procedures, wich is using the financal udf. i can say only one thing,
great, speed and easy to delploy and reuse.

perhaps udf is not "user defined functions" perhaps "ultra
datamanipulatin fast?" i am joking :-)

greetings daniel (a udf fan)

RSK schrieb:

[RSK]

Hi,
Can I use a udf in an ORDER BY statement?
(for example: order by SUBSTR(field,4,3))

Best regards,
RSK.

"RSK" <tecdi...@yahoo.com> wrote in message
news:41ff...@newsgroups.borland.com...