LTRIM(RTRIM())

[GrigoreDolghin]

Hello.

I'm brand new to SQL Server and coming from VFP.

There I have ALLTRIM function which is equivalent to LTRIM(RTRIM()).


Is there a short way to do this?

Thank you. Grigore Dolghin
Class Software
Bucharest, Romania

 

[youngun]

NO

 

[tlbroadbent]

There is no function equivalent to ALLTRIM in SQL Server. You could write your own in SQL 2000 but I prefer the standard functions in this case. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[GrigoreDolghin]

Thank you. Grigore Dolghin
Class Software
Bucharest, Romania