I would like to retrieve text from my access (mssql) database, but I would like the result to be truncated based on a set rule. For example:
Select Colour, Pitch from Pitches
will give me the colour and name of the pitch,
but, if say the result was "Green, Centre Pitch"
, I would like the results to be as follows: "GRE, Centre Pitch"
Obviously, if the colour was a three letter word then the truncation should not happen.