CODE EXAMPLE FOR SQL

tsql select everything before a character

SELECT LEFT(Column_name, CHARINDEX('/',Column_name)-1) Column_name from TABLE