Results 1 to 4 of 4

Thread: Trim

  1. 11-29-2006, 09:30 AM #1
    devon59
    devon59 is offline Registered User
    Join Date
    Nov 2006
    Posts
    1

    Trim or compress script in sql

    Hi there,
    Could somebody tell me the script on how to trim or compress the data to get rid of a space in front of the value in sql language?
    Thank you
    Last edited by devon59; 11-29-2006 at 09:40 AM.
    Reply With Quote Reply With Quote
  2. 11-29-2006, 01:06 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    On which RDBMS?
    Reply With Quote Reply With Quote
  3. 11-30-2006, 01:09 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try LTRIM.
    Reply With Quote Reply With Quote
  4. 12-01-2006, 10:59 AM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Try these...

    select LTRIM(columnname) from tablename
    select TRIM(columnname) from tablename
    select LEFTTRIM(columnname) from tablename
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules