I am new to using MSSQL and need help with SUBSTRING function.
i have a strings like below
s2-Total Solids - Std Method
A2-Alkalinity - ISO Method(%)
I would like to only get the data before the first "-" IE
so that i can link two tables in a sql view, would anyone know how i would complete this
can it be done like so?
RTRIM(LEFT (QCTEST.TESTNAME, 10))