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