Trimming a DB field

Results 1 to 2 of 2

Thread: Trimming a DB field

  1. #1
    Join Date
    Dec 1969

    Default Trimming a DB field

    I&#039;m trying to search a database that has a character field set to 4 characters. However not all the records are necessarily 4 character long. Thus they get padded on the left.<BR><BR>Does anyone know if there is an SQL statement that can be used to Trim the end of a field? None of the book I have seem to touch on it, and if they do, I don&#039;t know what to look up. Or is there perhaps a better solution?<BR><BR>Any help would be greatly appreciated.<BR><BR>Thanks,<BR>bch

  2. #2
    Join Date
    Dec 1969

    Default ltrim() -- :-) <nt>

    nope nothing here

Posting Permissions

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