hi
    In VB 6 we are using Trim for access.. For SQL Server 2000
what is the coresponding function
              pls help... its Urgent...:(

hi there..

doing a little google with this: "trim sql server 2000"

yelds:

http://sqlserver2000.databases.aspfa...ql-server.html

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

HI Gonzalo Bianchi sir
               I get the ans from ur link..
                     ans as follows...
TRIM(data)
This function combines both LTRIM() and LTRIM(); there is no equivalent in SQL Server. To mimic the functionality, you would combine the two functions:

-- Access:
SELECT TRIM(column)
SELECT LTRIM(RTRIM(column))

-- SQL Server:
SELECT LTRIM(RTRIM(column))

                     Thank u for ur Contribution Sir..
Pls continue ur good work..