[SQL] Re: [GENERAL] function

2000-09-05 Thread Ian Turner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > how can I write function which takes text from one field, replaces > some characters and puts it in other field? I have array with old and > new values. Probably best to do this as an embedded perl sql function. Then it is about 3 lines. Ian -

[SQL] Re: [GENERAL] function

2000-08-30 Thread Jan Wieck
Normunds wrote: > Hi all, > > how can I write function which takes text from one field, replaces > some characters and puts it in other field? I have array with old and > new values. > > For example: > old array = {'r', 'Z', 'o'} > new array = {'s', 'm', 't'} > old field value = 'Zorro' > new fiel