var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Removing delimiters
I have a database in which the
bankno is 29 and
acctno is 01-001-0000002
I need to write a query to get the data as "29010010000002" that is to concatenate both the fields and take out the delimiters in the second field. I know how to concatenate both
select bankno + acctno as acctnos from table;
But that will give me 2901-001-0000002. I need to modify the query so that I can remove the delimiters in the second column.
Can anyone give me an idea.
Thanx in advance.
replace(bankno + acctno,'-','')
as acctnos from table;