Ferenc <[email protected]> writes: > Hi > > I am new to Derby but a veteran with Oracle and Sql Server. > > reading the reference guide for 10.4, I can't find references to: > - REPLACE > - TRANSLATE > - MonthName or something like the Sql Server DatePart or Oracle TO_CHAR > functions > - LPAD, RPAD > - INITCAP > > We can create called formatting functions that we can apply to the data once > it is returned from the DB, but I would prefer to let the DB do this kind of > work.
You could use Derby stored functions to have such work done in the database rather than in the app, cf. http://db.apache.org/derby/docs/10.4/ref/rrefcreatefunctionstatement.html > > Also, I notice there is the generic CASE statement, but no clear indication > of something like > CASE {expression) when Value 1 then .... when Value2 ... else ..... end > Is this type of CASe statement supported? Is this what you need? It seems to cover your case.. http://db.apache.org/derby/docs/10.4/ref/rrefcase.html Hope this helps, Dag
