SeanFromIT Posted February 1, 2007 Share Posted February 1, 2007 How do I chop off the last 3 characters of a varchar without knowing how many characters each row actually contains? Quote Link to comment https://forums.phpfreaks.com/topic/36594-solved-chop-end-of-varchar/ Share on other sites More sharing options...
effigy Posted February 1, 2007 Share Posted February 1, 2007 SELECT LEFT(field, LENGTH(field) - 3) FROM table Quote Link to comment https://forums.phpfreaks.com/topic/36594-solved-chop-end-of-varchar/#findComment-174302 Share on other sites More sharing options...
SeanFromIT Posted February 1, 2007 Author Share Posted February 1, 2007 Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/36594-solved-chop-end-of-varchar/#findComment-174542 Share on other sites More sharing options...
janroald Posted February 1, 2007 Share Posted February 1, 2007 never mind ... Quote Link to comment https://forums.phpfreaks.com/topic/36594-solved-chop-end-of-varchar/#findComment-174543 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.