Results 1 to 5 of 5

Thread: [RESOLVED] trim character function?

  1. Nov 9th, 2006, 11:57 PM #1
    drpcken
    drpcken is offline

    Thread Starter
    Fanatic Member drpcken's Avatar
    Join Date
    Apr 2004
    Location
    devenv
    Posts
    591

    Resolved [RESOLVED] trim character function?

    Is there a function that will trim a designated amount of characters off the right (or left) end of a string? I'm using sql server 2005.

    Thanks!
    Last edited by drpcken; Nov 10th, 2006 at 12:01 AM.

    In the unlikely event that I answer your question correctly, please Rate my post

    Using Visual Studio 2005 Professional
    Reply With Quote Reply With Quote
  2. Nov 10th, 2006, 01:30 AM #2
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: trim character function?

    If Im not wrong SubStr or SubString is the function to extract specific chars from a given string...its equivalent to Mid function is vb...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  3. Nov 10th, 2006, 01:34 AM #3
    drpcken
    drpcken is offline

    Thread Starter
    Fanatic Member drpcken's Avatar
    Join Date
    Apr 2004
    Location
    devenv
    Posts
    591

    Re: trim character function?

    excellent! I used the substring category to start from the beginning, then got the length of the string and subtracted the number of characters i wanted to cut off.

    Code:
    select substring(field, 1, len(field) -2)) from table
    Thanks!

    In the unlikely event that I answer your question correctly, please Rate my post

    Using Visual Studio 2005 Professional
    Reply With Quote Reply With Quote
  4. Nov 10th, 2006, 01:37 AM #4
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: [RESOLVED] trim character function?

    you are most welcome...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  6. Nov 10th, 2006, 10:21 AM #5
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: [RESOLVED] trim character function?

    Just an FYI, there is also a Left (and Right) function:
    Code:
    select Left(field, len(field) -2)) from table
    ..it may be faster, but I'm not sure.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    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


Click Here to Expand Forum to Full Width