Looked at Carl's UDF that he posted in Sample Application. I liked it very much and hopefully this will inspire other people to make their own UDF library and post them here for others to use. I liked the way it he used "@" in front to make it clear it is function and it returns value. However in order to differentiate it from other hard-coded functions, I would name UDF ending with udf, more like @Pad_UDF (  ).

Initially I thought that one will have to make @Trim_UDF ( ) to remove leading and trailing spaces when lookup done or used in some other string operations or when they are printed. But to my pleasant surprise, Sesame removes the spaces automatically and that probably explain why @trim ( ) is not hard-coded.