Posted by Andreas Eibach on 07/30/05 18:43

This function is supposed to strip a fixed N characters from the right,
reducing "REWARDING" to "REWARD" with myterm in column C, and N = 3.
Currently I have:

SELECT LEFT (myterm, LENGTH(myterm)-N) from C

Can this be shortened a bit?

Thanks,

Andreas

• Next in forum: MySQL MaxDB 7.6.00.10 Joins und Subquery
• Prev in forum: Is it possible to change part of a db-fields content by sql statement?
• Thread view: Please help in making this function a bit shorter

[Reply to this message]