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 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 Share on other sites More sharing options...
SeanFromIT Posted February 1, 2007 Author Share Posted February 1, 2007 Thanks! Quote Link to comment Share on other sites More sharing options...
janroald Posted February 1, 2007 Share Posted February 1, 2007 never mind ... Quote Link to comment 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.