DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Trim Sql Not Getting It

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    Trim Sql Not Getting It

    thanks in advance

    MY SQL QUERY OUTPUT SHOWS LIKE THIS

    NAME
    ---------
    GAJANAN KINI
    PRASHANT KINI
    AJAY KINI

    i want the output to be like this

    NAME
    --------------
    GAJANANKINI
    PRASHANTKINI
    AJAYKINI

    i tried but not getting this output. can someone advise me

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    So, what is the query that you are trying to run?

    you could try

    select replace (name,'') from table;

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    SQL> select replace('abcd xyz',' ','') from dual ;

    REPLACE
    -------
    abcdxyz


    Tamil

Posting Permissions

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


Click Here to Expand Forum to Full Width