Trying to remove characters from query result. In following file; "68 Widewater Front 2_150x0.jpg", which is a thumbnail image.
I am trying to get the query to trim the "_150x0" characters from the result so I can display the thumbnail, rather than the full image.
Query returns "68 Widewater Front 2.jpg", which is the file name for the full image in the database.
Below is how I have set up query, but it's not working.