.... follow up.
Is there any problem with declaring a function TWICE... with different
names ??
To pretty up my SQL, I'd like not to use F_PROPERCASE(CITY)... but
rather something like CS(CITY)
Seems to work ok, but I just wanted to see if I'm playing with fire ! I
need all the FireBird Karma available !
Thanks
rich

> DECLARE EXTERNAL FUNCTION cs
> CSTRING(32760)
> RETURNS CSTRING(32760) FREE_IT
> ENTRY_POINT 'propercase' MODULE_NAME 'FreeAdhocUDF';

Rich Pinder wrote:

>
> THANKS so much. This will work with the char set I'm using.
> (you saved me again Helen... I began slogging back into writing my own
> UDF, and got held up with my confusion about REFERECE and VALUE, etc...
> and was considering crafting a post !!
>
> Take care, and have a great weekend AND Holiday time
>
> Rich
>
> Helen Borrie wrote:
> >
> > At 01:57 AM 15/12/2007, you wrote:
> > >Is there a function or udf that allows converting address (or name)
> info
> > >into mixed case:
> > >
> > >RICH PINDER ----> Rich Pinder
> > >rich pinder ----> Rich Pinder
> > >172 W WOODSIDE AVE -----> 172 W Woodside Ave
> > >
> > >I'd like to do this thru a SQL statement.
> > >
> > >I've looked thru the UDF libraries I have, and don't see one.
> >
> > FreeUDFLib has a ProperCase() function that will work on single-byte
> > character set strings with the upper/lower mapping rules for the
> > standard ASCII collation. I don't know offhand of any propercasing UDF
> > that could be applied to other character sets or collations, though.
> >
> > ./heLen
> >
> >
>
>