var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Build Query Result
Im tring to build a custum field query without sucess.
Here is the problem, i have two fields that have to concatenate in order to have a result with difined size.
integer x = 1234
varchar(10) y= "hithere"
The result must be x + y = " 001234 000hithere"
For start if i try NVL(REPLACE(x[1,6]," ","0"),"000000") it dosent work for Integer.
If i aplly it to the y: NVL(REPLACE(y[1,10]," ","0"),"0000000000") the result will be "hithere000".
Any one can help?
hardly readable ( therefore hardly maintainable ) query ....
why don't you try to build a stored procedure,
where you can handle strings more easily than within the very query ?
You won't be affected by loss of performance, and your code can be much more
versatile and debuggable...
Tags for this Thread