SQL SERVER LEFT FORMULA

SQL SERVER LEFT FORMULA

-- THEORY

-- SELECT LEFT('FIELD VALUE', [NUMBER OF CHARACTERS TO EXTRACT FROM THE LEFT SIDE OF FIELD VALUE]) AS [ALIAS NAME FOR VALUE];

-- EXAMPLE

SELECT LEFT('TEST01', 4) AS [LEFT STRING EXTRACT];