Menu
Hi.. I have various URL’s in a database that I want to trim before I display them. I was using the SELECT RIGHT(URL,8) method, however this is only useful if I want to keep the final 8 characters. I actually want the characters at the end of the string that immediately follow an “=” sign, but they will very with length, depending on the URL.
eg.URL1. /index…=id=24495659
eg.URL2. /index…=id=the_one_and_only
Does anyone have any ideas about how I might tackle this?
Many thanks,
Peter