reduce spaces between data


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: reduce spaces between data

  1. #1
    Humair Guest

    reduce spaces between data


    hi
    i have table named t1 having column

    a b
    ----------------
    1 a s d
    2 c v b
    3 s d f g h
    4 d f
    5 b g ty gggg

    then i want

    display a record of column "b"
    like this

    asd
    cvb
    sdfgh
    df
    bgtygggg

    so on & so on

    basicaly i am reduce spaces between data

    any method to reduce spaces in sql server only?
    bye

  2. #2
    Paul Mc Guest

    Re: reduce spaces between data


    G'day Humair.


    >a b
    >----------------
    >1 a s d
    >2 c v b
    >3 s d f g h
    >4 d f
    >5 b g ty gggg


    Try this:

    Select REPLACE([b], ' ', '') as B_NoSpaces From t1

    HTH,
    Cheers,
    Paul


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center