that did it - thanks!
Hi Mike, I think the problem is the datatype of the function's return value. The VARCHAR datatype needs a length. This should work: CREATE FUNCTION FUNC_NO_ARGS() RETURNS VARCHAR( 100 ) ... Hope this helps, -Rick -- View this message in context: http://www.nabble.com/cannot-create-a-function-with-no-arguments-tf4392364.html#a12524824 Sent from the Apache Derby Users mailing list archive at Nabble.com.