afternoon everyone,
I am new to using MSSQL and need help with SUBSTRING function.
i have a strings like below
s2-Total Solids - Std Method
V1E-RVT4/2.5@20degC Initial
V1Y-LVT2/60@20deg Initial
A2-Alkalinity - ISO Method(%)
I would like to only get the data before the first "-" IE
s2
V1E
V1Y
A2
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))