subject:"RE\: Trim in SQL"

RE: Trim in SQL

2002-03-04 Thread Mark A. Kruger - CFG

04, 2002 6:38 PM To: CF-Talk Subject: Re: Trim in SQL - Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 3:07 PM Subject: RE: Trim in SQL > There is no TRIM(), but there is a RTIM

Re: Trim in SQL

2002-03-04 Thread James Sleeman

- Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 3:07 PM Subject: RE: Trim in SQL > There is no TRIM(), but there is a RTIM() and a LTRIM(): > > SELECT foo from bar

RE: Trim in SQL

2002-03-04 Thread Ben Forta

There is no TRIM(), but there is a RTIM() and a LTRIM(): SELECT foo from bar WHERE RTRIM(LTRIM(narf)) is like 'blah' -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 9:07 PM To: CF-Talk Subject: OT: Trim in SQL Anybody know if there is a w