I pulling a list of part names from a database to populate a dropdown box for the user to choose from. I want to cut the length of the returned string to a fixed length. rtrim() only seems to cut whitespace, where I want to just take the first 25 characters. I'm not concerned with what the text will look like if it cuts in the middle of a word, etc.

    Use [man]substr/man. You may also be able to use a similiar function in SQL.

      Write a Reply...