RE: Auto Truncate of Spaces

This seems to be a somewhat common desire which I have yet to really understand. Is it just because it makes the code look neater, or is there some other issue I am missing? Will >===== Original Message From Jake Colman <colman@ppllc.com> ===== >Is there a way to arrange for CHAR data fetched from the database to be >auto-truncated of any trailing spaces? I do NOT want to use the TRIM >function for each column to be truncated. I am looking for a lower-level >solution, perhaps using some ODBC parameter. > >Thanks! > >-- >Jake Colman > >Principia Partners LLC Phone: (201) 946-0300 >Harborside Financial Center Fax: (201) 946-0320 >902 Plaza II Beeper: (800) 928-4640 >Jersey City, NJ 07311 E-mail: colman@ppllc.com > E-mail: jcolman@jnc.com > web: http://www.ppllc.com > >microsoft: "where do you want to go today?" >linux: "where do you want to go tomorrow?" >BSD: "are you guys coming, or what?" ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------