Is there any way of declaring ones own function (not external) like
Upper, cast, stc in database.

What I want is a way to have the foolowing statement

select * from tableA a
where a.Field = functionA (Val);

where functionA returns some value based on input parameter Val.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz