|
 |
access thread: Trim problem in SQL Server
Message #1 by "Rogers, Robert" <rrogers@b...> on Fri, 17 Aug 2001 09:40:11 -0400
|
|
This question is for the SQL Server people that are using ACCESS as a front
end. If you can't you the TRIM function in <?xml:namespace prefix = o ns
"urn:schemas-microsoft-com:office:office" />
SQL what's another function that you can use that gives you the same
results?
Robert L. Rogers
Rexel Branch Electric
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Fri, 17 Aug 2001 07:30:58 -0700
|
|
I believe you can do LTrim(RTrim(<my field>)).
HTH,
-Roy
-----Original Message-----
From: Rogers, Robert [mailto:rrogers@b...]
Sent: Friday, August 17, 2001 6:40 AM
To: Access
Subject: [access] Trim problem in SQL Server
This question is for the SQL Server people that are using ACCESS as a front
end. If you can't you the TRIM function in <?xml:namespace prefix = o ns
"urn:schemas-microsoft-com:office:office" />
SQL what's another function that you can use that gives you the same
results?
Robert L. Rogers
Rexel Branch Electric
Message #3 by "Rogers, Robert" <rrogers@b...> on Fri, 17 Aug 2001 10:33:59 -0400
|
|
THANKS
-----Original Message-----
From: Pardee, Roy E [mailto:roy.e.pardee@l...]
Sent: Friday, August 17, 2001 10:31 AM
To: Access
Subject: [access] RE: Trim problem in SQL Server
I believe you can do LTrim(RTrim(<my field>)).
HTH,
-Roy
-----Original Message-----
From: Rogers, Robert [mailto:rrogers@b...]
Sent: Friday, August 17, 2001 6:40 AM
To: Access
Subject: [access] Trim problem in SQL Server
This question is for the SQL Server people that are using ACCESS as a front
end. If you can't you the TRIM function in <?xml:namespace prefix = o ns
"urn:schemas-microsoft-com:office:office" />
SQL what's another function that you can use that gives you the same
results?
Robert L. Rogers
Rexel Branch Electric
|
|
|
View Cart
