Hi,

Can someone tell me if it is possible to create a user defined scalar
function in Pervasive?

eg say I wanted to write a function called MyFixIt that changed all A's to
B's in a specified string.

Then, given the following table:

NameList

Name
ANDREW
SIMON
MARK

The Query:

Select Name,MyFixIt(Name) From NameList;

Would Give me:

ANDREW BANDREW
SIMON SIMON
MARK MBRK

Obviously my actual function is much more complicated than this, so please
don't suggest alternative ways of acomplishing the above example. It is how
to write my own function that I'm interested in.

Thanks,

Chris.


--
Please remove shoes to reply

But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.

Not at this time...
BB

ChrisM wrote: