[SOLVED] Many sql statements are working in SQL Server 2000.Plz Help?

#1 (**permalink**) 06-10-2007, 04:21 PM

I/m running SQL SERVER 2000 at my home and Commands like LTRIM,RTRIM,LPAD,LPAD and also some thing(some constraints) even in Create Table is not Working?Why is this happening.Does SQL SERVER does not support these basic commands??
Many sql statements are NOT working in SQL Server 2000.Plz Help?

#2 (**permalink**) 06-10-2007, 04:21 PM

SQL 2000 definitely supports LTRIM and RTRIM, dunno about the others.

Are you sure you're using the correct syntax? Be sure to check the documentation.

#3 (**permalink**) 06-10-2007, 04:21 PM

Hard to tell. SQL 2000 supports those commands. Might want to paste some code on one or two that are not working. Usually it is due to syntax if it doesn't work. If you put some examples, I'll be happy to take a look.

Good luck.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode