Tags for unexpected
SQL UDF for LPAD (left-pad) giving unexpected results
Hello, Are there any doc's which discuss SQL UDF's?  (Especially the various qualifiers in the CREATE FUNCTION statement).  I am trying to determine why my regular SQL works as expected, but when you put the same code into an SQL UDF, it returns unexpected results.  Any insight would be greatly appreciated.
udf sql create function unexpected lpad left pad