ryanschefke Posted December 21, 2008 Share Posted December 21, 2008 Hello, Is there a way to limit the size of a string returned from a select statement? For example, it is a long URL but I only want to display the first 50 characters. The way I am using the select statement in a particular section of code doesn't allow for any post processing so I need to format the string inside the select statement. Thank you, Ryan Quote Link to comment https://forums.phpfreaks.com/topic/137866-limit-size-of-url-string/ Share on other sites More sharing options...
fenway Posted December 22, 2008 Share Posted December 22, 2008 Use LEFT( yourField, 50). Quote Link to comment https://forums.phpfreaks.com/topic/137866-limit-size-of-url-string/#findComment-721574 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.