I want to return a row from a table through sql. Now the row returns this:
I want to return it like this:
I am using SQL Server so i tried something like this:
SUBSTRING(SI.Location, CHARINDEX('/', 2), 1) AS Testing
But this returns as blank so it doesn't work. Any ideas how i can get this working?
SI is the name of the table and Location is the row.