• Trim Between Characters

    How do I Trim the text after a spcific character? (ie. www.website.com#http://www.website.com#) Trimed to www.website.com

    MAGco5 pointsBadges:
  • Trimming Values with SQL Server Express 2005

    I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn't work for me. I can't use LEFT or RIGHT before the column because the column length is variable. I...

    Eabouzeid175 pointsBadges:
  • Can we use TRIM in WRKQRY?

    I am formaing up one field in Define Result Fields Field JOBNM Expression x9jbno||'/'||x9jbus||'/'||x9jbnm Here can I use TRIM function with x9jbus filed to avoid blanks If anybody knows pls let me know at pankajmahajan@hsbc.co.in

    Pankaj2rmca15 pointsBadges:
  • Trim Trailling Spaces

    How do I trim trailling spaces when I concatinate 2 character fields. Like when you concat names there is a big space between the 2 names.

    Arnelr45 pointsBadges:
  • SQL Right Trim Nulls

    How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls

    Tim442025 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.