Board index » Database Programming

All times are UTC



 Trim a variable in SQL 6.5 Trigger 
Author Message
Jakes de Jage
#1 / 2
 Trim a variable in SQL 6.5 Trigger
How do I trim a variable in a trigger on a table?
My code will look like this morealess.




The trim statement gives me an error.
Can anyboby please help?

Regards
Jakes



Sat, 31 Aug 2002 03:00:00 GMT
Kirk
#2 / 2
 Trim a variable in SQL 6.5 Trigger

SQL Server (T-SQL) only supports the LTRIM and RTRIM functions.  Using them
both you can get what you need.



Quote:
> How do I trim a variable in a trigger on a table?
> My code will look like this morealess.




> The trim statement gives me an error.
> Can anyboby please help?

> Regards
> Jakes



Sat, 31 Aug 2002 03:00:00 GMT
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Data and binary data is trimmed in SQL 7 but not in SQL 6.5

2. SQL Server 6.5 trims varchars

3. Triggers in SQL ver 6.5 and SQL ver 7.0

4. SQL Server 6.5 Dynamic SQL inside Trigger to Access deleted Table

5. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

6. trigger differences between SQL 6.5 and SQL 2000

7. sp_OAMethod and variable trimming

8. Replace column name with variable - SQL 6.5

9. Reading data of type TEXT from database (SQL 6.5) and assigning it to a variable

10. Extremely Variable SQL 6.5 Performance

11. ... and trim (cod_deleg) = trim (:cod_deleg) stop working when

12. More: Variable performance with IIS3, ASP, MDAC 1.5 and SQL 6.5

 
Powered by phpBB® Forum Software