Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    40

    Unanswered: Removing delimiters

    Hi

    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
    i.e.

    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.

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    select
    replace(bankno + acctno,'-','')
    as acctnos from table;
    --
    kukuk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •