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? 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 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! 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 ... 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
Archived
This topic is now archived and is closed to further replies.