[AccessD] Trim function in SqlServer

Yep, Makes sense. Thanks!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Tuesday, April 24, 2007 11:20 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Trim function in SqlServer

SELECT LTRIM(RTRIM(' foo ')) 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, April 24, 2007 7:59 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Trim function in SqlServer

I know there is an RTRIM() and LTRIM() in SQLServer, but is there one that
trims both ends, like the Access TRIM() function?

I want to do this in a SQLServer view.

John



 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com